Re: How to write in Postgres

[Alban Hertroys <haramrae@xxxxxxxxx>]

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