Thread: Can someone help me with this function?

Can someone help me with this function?

From
"Christopher Kings-Lynne"
Date:
Hi Guys,

I can't get this thing to work properly - the apostrophes are giving me
nightmares!

Can someone tell me why I get:

NOTICE:  plpgsql: ERROR during compile of kl_setnull near line 44
ERROR:  parse error at or near ""

I believe the error is in the '''' somewhere...

Thanks,

Chris

Attachment

Re: Can someone help me with this function?

From
"Christopher Kings-Lynne"
Date:
Don't worry - got it figured - forgot the 'END IF'!!!

Chris

> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Christopher
> Kings-Lynne
> Sent: Friday, 22 February 2002 4:52 PM
> To: pgsql-sql@postgresql.org
> Subject: [SQL] Can someone help me with this function?
> 
> 
> Hi Guys,
> 
> I can't get this thing to work properly - the apostrophes are giving me
> nightmares!
> 
> Can someone tell me why I get:
> 
> NOTICE:  plpgsql: ERROR during compile of kl_setnull near line 44
> ERROR:  parse error at or near ""
> 
> I believe the error is in the '''' somewhere...
> 
> Thanks,
> 
> Chris
>