Postgres Pro
Downloads
Home   >   mailing lists

Re: syntax error at or near "Hs" at character 1182 - Mailing list pgsql-novice

From Tom Lane
Subject Re: syntax error at or near "Hs" at character 1182
Date
Msg-id 26568.1097876384@sss.pgh.pa.us
Whole thread Raw
In response to syntax error at or near "Hs" at character 1182  (Kumar S <ps_postgres@yahoo.com>)
List pgsql-novice
Tree view 
Kumar S <ps_postgres@yahoo.com> writes:
> INSERT INTO cdna_exp
> ...
> VALUES (
>
"9216","18495","IMAGE:262035","NULL","ESTs","Hs.269034","H98688","NULL","107662","227","NULL","NULL","NULL","NULL","245","137","NULL","90","298","30","NULL","NULL","NULL","NULL","339","268","NULL","406","45","451","NULL","NULL","0.584","NULL","0","-0.987","NULL","NULL","0.302","40","NULL","19","NULL","3","1.981","0.333","NULL","NULL","0.505","NULL","0.484","NULL","NULL","1272","52","NULL","NULL","960","968","1005","1013","16","24","24","GF201:96(69H12):384(24P24)","24","P","24","0","Y","U");

I think you want single quotes, not double quotes, around those
constants.

            regards, tom lane

pgsql-novice by date:

Previous
From: Kumar S
Date:
Subject: syntax error at or near "Hs" at character 1182
Next
From: Kumar S
Date:
Subject: invalid input syntax for integer: "NULL"