Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group