Re: newbie sql question...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sunday 25 May 2003 22:09, Jason Ziegler wrote:
> Hello folks, I'm new to this list, and have been putting up with mysql
> for too long, so please forgive me for asking such a newbie question as
> this:
>
> I have a query that works in mysql:
> "INSERT INTO table1 ( id, column2, column3 ) VALUES ( '1', 'text
> stuff', 'text stuff' ), ( '2', 'more text', 'even more text')"
>
> When I try this in postgresql, it won't work:
> "INSERT INTO table1 ( 'id', 'column2', 'column3' ) VALUES ( '1', 'text
> stuff', 'text stuff' ), ( '2', 'more text', 'even more text')"
>
> I think I'm getting the syntax wrong for stringing together multiple
> value sets or something.
> Can anyone point me in the correct direction of how to do this
> properly, please?
>

If you take a peek at the INSERT documentation, you'll notice that the syntax
is invalid. You can find documentation on all of the SQL commands in the
fifth book -- "PostgreSQL 7.3.2 Reference Manual" that is including with the
PostgreSQL documentation.

- --
Jonathan Gardner <jgardner(at)jonathangardner(dot)net>
(was jgardn(at)alumni(dot)washington(dot)edu)
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE+3hCVWgwF3QvpWNwRAg0IAJ9PBoIDI2NnPcY1CH/ImxR1w3j9IgCfQqrb
8zEi8lWJN5EATfex+xInt9I=
=VHDc
-----END PGP SIGNATURE-----