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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: syntax error at or near "Hs" at character 1182
Дата
Msg-id 26568.1097876384@sss.pgh.pa.us
обсуждение исходный текст
Ответ на syntax error at or near "Hs" at character 1182  (Kumar S <ps_postgres@yahoo.com>)
Список pgsql-novice
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 по дате отправления:

Предыдущее
От: Kumar S
Дата:
Сообщение: syntax error at or near "Hs" at character 1182
Следующее
От: Kumar S
Дата:
Сообщение: invalid input syntax for integer: "NULL"