How to write in Postgres
От | |
---|---|
Тема | How to write in Postgres |
Дата | |
Msg-id | 20120207070337.c760ddbd7c0975bc4b045766db7d895c.8c8c67ccf2.wbe@email16.secureserver.net обсуждение исходный текст |
Ответы |
Re: How to write in Postgres
Re: How to write in Postgres |
Список | pgsql-general |
<table align=3D"center" style=3D"empty-cells: show;" bgcolor=3D"#ffffff" bo= rder=3D"0" cellpadding=3D"0" cellspacing=3D"0" width=3D"100%"><td style= =3D"text-align: left; background-repeat: no-repeat;" align=3D"left"; height= =3D"72" colspan=3D"1" background=3D"cid:top@2d09f79b45a0399ec444c52bf160b4d= e"<div style=3D"padding: 5= px; overflow-x: auto;"><span style=3D= "font-family:Verdana; color:#000000; font-size:10pt;"> I have a S= QL statement that I'm trying to convert from a SQL Anywhere function, but I= 'm getting a error. Can't seem to figure out why. Is the substr= ing usage incorrect and if it is how do I accomplish this. I'm trying= to step through the item 1 character at a time so that I can reformat the = input correctly. This is inside a WHILE loop (While idx < 11 loop. idx has been init= ialized to 1 and is declared as a integer. set chr =3D substr(lfeid,idx,1); How do I convert this to PostGres. I'm getting a error ERROR: syntax error at or near "("LINE 23: set chr =3D substr(lfei= d,idx,1); Michael Gould Intermodal Software Solutions, LLC 904-226-0978</d= iv>=
В списке pgsql-general по дате отправления: