On Tue, Feb 7, 2012 at 8:03 AM, <mgo...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
