On 7 February 2012 15:03, <mgo...@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.