How to write in Postgres

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);








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);





Michael Gould


Intermodal Software Solutions, LLC


904-226-0978