On Fri, Aug 10, 2007 at 10:17:56AM -0500, Zoltan Tomory wrote:

The documentation examples at 3.1.6.1 have two variations:

Insert into TABLE (COL, …) values (COL*,…); which works where the values match the pattern of columns specified

Insert into TABLE values (COL,…); which seems not to work

in this case you should list values for each column in the table 'TABLE'.

Is this a typo in the documentation or have I committed a syntax error?

Also, I have syntax question about something I have not tried out. If I have a column I use for Last Name, how could I insert ‘O’Connell’ as the field is delimited with single quotes?

escape using \ or '. Niels

TIA

Zoltan Tomory

[1]zoltan.tomory@mobot.org

References

1. mailto:zoltan.tomory@mobot.org

------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ 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