On 7 February 2012 15:03, <mgould(at)isstrucksoftware(dot)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.