Re: syntax error at or near "Hs" at character 1182

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kumar S <ps_postgres(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: syntax error at or near "Hs" at character 1182
Date: 2004-10-15 21:39:44
Message-ID: 26568.1097876384@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Kumar S <ps_postgres(at)yahoo(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Kumar S 2004-10-15 21:55:13 invalid input syntax for integer: "NULL"
Previous Message Kumar S 2004-10-15 21:15:45 syntax error at or near "Hs" at character 1182