SQL parse error
От | Borek Lupoměský |
---|---|
Тема | SQL parse error |
Дата | |
Msg-id | Pine.LNX.4.21.0012121036260.26258-100000@diaspar.ujep.cz обсуждение исходный текст |
Ответы |
RE: SQL parse error
|
Список | pgsql-sql |
Hello all, My following problem is: swports=# select substring(cp from 1 for 4)::int4 from out2cp; ERROR: pg_atoi: error in "6.1,": can't parse ".1," SQL syntax is apparently OK. When I omit the typecast, the query works: swports=# select substring(cp from 1 for 4) from out2cp;substr --------318231823182 -8<- text deleted --- The cp entries are varchars in form NNNN.N, where N is numeral. So can someone explain why the parse error? Bye Borek -- ===================================================================== BOREK LUPOMESKY Usti nad Labem, Czech Republic, Europe WWW: http://www.volny.cz/borekl/ PGP keyid: B6A06AEB ==========[ MIME/ISO-8859-2 & PGP encrypted mail welcome ]===========
В списке pgsql-sql по дате отправления: