How to write in Postgres

On 7 February 2012 15:03, <mgould@isstrucksoftware.net> wrote:

How do I convert this to PostGres. I'm getting a error
ERROR: syntax error at or near "("
LINE 23: set chr = substr(lfeid,idx,1);

Assuming you are writing this as pl/pgsql code, the way you do your
variable assignments is wrong on two accounts. Find some time to read the
chapter on pl/pgsql if possible ;)

Anyway, that line should read:
chr := substr(lfeid,idx,1);

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

On Tue, Feb 7, 2012 at 8:03 AM, <mgould@isstrucksoftware.net> wrote:

 I have a SQL 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 substring 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 initialized to 1 and is declared as a integer.
set chr = substr(lfeid,idx,1);

in plpgsql:

WHILE idx < 11
LOOP
chr := substr(lfeid,idx,1);
END LOOP;

http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html

I could probably help you work it into a single query if you provided
some more detail.

merlin