Re: [SQL] Question #4 about PL/PGSQL

2001-01-16 Thread Jan Wieck
Josh Berkus wrote: > Folks, > > Oh, yes, one more: > > 4. If I pass a NULL to any of the parameters of a PL/PGSQL > function, any (other) VARCHAR parameters are set to NULL as > well. Fixed in 7.1. Impossible to fix in 7.0.x or earlier due to missing capabilities of the function manage

Re: [SQL] Question #4 about PL/PGSQL

2001-01-15 Thread Josh Berkus
Tom, > Damn! When is the "holy grail" of PostgreSQL going to be > stable enough to use? Beta3 still has a "not advisable > for > production" warning, and I'm being tied up in knots by > the > number of things I need in 7.1. Ooops! That may have sounded a little harsh. I am a bit desperate, b

Re: [SQL] Question #4 about PL/PGSQL

2001-01-15 Thread Josh Berkus
Tom, > Not only varchar --- any other parameters, period. And > not only that, > but the result is taken as NULL no matter what you try to > return. Not quite. I tried the following: Parameters: $1=integer, $2=NULL, $3=varchar And I had the function test for nulls. It read the first paramet

Re: [SQL] Question #4 about PL/PGSQL

2001-01-15 Thread Tom Lane
"Josh Berkus" <[EMAIL PROTECTED]> writes: > 4. If I pass a NULL to any of the parameters of a PL/PGSQL > function, any (other) VARCHAR parameters are set to NULL as > well. Not only varchar --- any other parameters, period. And not only that, but the result is taken as NULL no matter what you

[SQL] Question #4 about PL/PGSQL

2001-01-15 Thread Josh Berkus
Folks, Oh, yes, one more: 4. If I pass a NULL to any of the parameters of a PL/PGSQL function, any (other) VARCHAR parameters are set to NULL as well. Thanks! -Josh