From: | Jonathan Gardner <jgardner(at)jonathangardner(dot)net> |
---|---|
To: | Jason Ziegler <jasonzig(at)mac(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: newbie sql question... |
Date: | 2003-06-04 15:30:29 |
Message-ID: | 200306040830.31031.jgardner@jonathangardner.net |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Rory Campbell-Lange | 2003-06-04 17:23:13 | CAST to integer problem |
Previous Message | Avi Schwartz | 2003-06-04 15:26:22 | Nulls get converted to 0 problem |