From: | Joel Stevenson <atani(at)redfish(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Explicit column naming on INSERT question |
Date: | 2001-05-17 02:27:47 |
Message-ID: | a05001901b728e54d914b@[192.168.1.100] |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Buenas tardes, all.
I'm puzzled by my inability to use the following INSERT statement:
INSERT INTO RM_USER VALUES(RM_USER.ID, RM_USER.FIRST_NAME) VALUES(1, 'DUBYA')
it seems that postgres is unhappy about the explicit column naming
(e.g. 'RM_USER.ID' instead of just 'ID') because I end up with
either:
ERROR: parser: parse error at or near "values"
or
ERROR: parser: parse error at or near "."
Take out the explicit table name and everything is fine. The real
problem is that I've got a significant amount of code that uses this
explicit naming scheme (whether it's really the best thing to do or
not, that's the way it is now) and oh what a headache I'll have if I
have to go through it all and change this. I'm running 7.0.2, does
anybody know if this is also the case in any more recent versions of
postgres?
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Gordon Runkle | 2001-05-17 03:14:30 | Re: DB2 on Linux beats MS where would postgres end up? |
Previous Message | Alan Young | 2001-05-17 01:57:35 | Am I headed in the right direction? (long) |