April 15th, 2008, 05:17 PM
|
|
Registered User
|
|
Join Date: Sep 2007
Posts: 22
Time spent in forums: 5 h 17 m
Reputation Power: 0
|
|
|
INSERT INTO Syntax
This is more of a syntax question, as I've found the solution while typing it out.
Code:
Table "temp.activelist"
Column | Type | Modifiers
-----------+-----------------------+------------------------------
user | character varying(25) | not null
guest | smallint | not null default 0::smallint
time | integer | not null
view | character varying(10) |
boardid | integer |
messageid | integer |
Indexes:
"activelist_time_idx" btree ("time")
Code:
dbname=# INSERT INTO temp.activelist (time,guest,user) VALUES (2,3,4);
ERROR: syntax error at or near "user" at character 42
LINE 1: INSERT INTO temp.activelist (time,guest,user) VALUES (2,3,4...
^
dbname=# INSERT INTO temp.activelist (time,guest,user) VALUES (2,3,'4');
ERROR: syntax error at or near "user" at character 42
LINE 1: INSERT INTO temp.activelist (time,guest,user) VALUES (2,3,'...
^
Code:
dbname=# INSERT INTO temp.activelist ("user",time,guest) VALUES (2, 3,'4');
INSERT 0 1
dbname=# INSERT INTO temp.activelist (time,guest,"user") VALUES (2,3,'4');
INSERT 0 1
dbname=# INSERT INTO temp.activelist ("time","guest","user") VALUES (2,3,4);
INSERT 0 1
The problem occurs when user is not in quotes. Is this a reserved word or is there something else going on?
Thanks for your help.
vol7ron
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
