RE: [GENERAL] PL/pgSQL syntax/usage question

2000-02-02 Thread Stephane FILLON
executing PL/pgSQL function textkey > DEBUG: line 6 at select into variables > AbortCurrentTransaction > Replace the line "where person_id=id" with "where person_id = id". Add a space between = and id as PL/pgSQL trie to interpret the operator =$2 that doesn't exist. Regards, Stephane FILLON

RE: [GENERAL] plpgsql problem: relocation error

1999-01-02 Thread Stephane FILLON
Try to replace the following: return t; by return ''t''; and return f; by return ''f''; It's not a double quote but a quote quote :-) -Message d'origine- De: Andrew Perrin - Demography [SMTP:[EMAIL PROTECTED]] Date: mercredi 3 novembre 1999 07:18 A: [EMAIL PROTECTED] Objet