I followed up the original post, and I don't know if the follow-up has been
posted or not.
The trick is: do not use quotes ('') for variables declared in the declare
secton.
Thanks.
-----Original Message-----
From: Stephan Szabo [mailto:sszabo@megazone23.bigpanda.com]
Sent: Tuesday, October 30, 2001 12:32 PM
To: Zhou, Lixin
Cc: 'pgsql-general@postgresql.org'
Subject: Re: [GENERAL] create function question
On Mon, 29 Oct 2001, Zhou, Lixin wrote:
> The following function always returns NULL when I call it like this:
>
> select get_bundle_id('1009699', '1', '1').
>
> If I replace b, r, c with '1009699', '1', '1' inside the function body, it
> returns the correct id!
Probably you shouldn't double quote the b r and c in the function since
that'd be the constants not the variables.