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.