On Fri, Dec 15, 2006 at 12:33:17PM +0100, JLP00993@correo.aeat.es wrote:

Hello again!

I have another question about data load.

How can I load null fields into a table with COPY command?.

For example, if I have the next row ...

123;Load test;;;;New field;0

... with fields separated by ';'.

Now, I have got next error message:

ERROR = !ERROR: decimal wrong format

for decimal fields and varchar fields are loaded as empty string ("") instead of null.

Simply add NULL instead of the empty strings should do the trick. Niels

Thanks in advance!

------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl