pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Question #4 about PL/PGSQL
4+ messages / 2 participants
[nested] [flat]

* Question #4 about PL/PGSQL
@ 2001-01-16 03:10 Josh Berkus <josh@agliodbs.com>
  2001-01-16 04:58 ` Re: Question #4 about PL/PGSQL Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 4+ messages in thread

From: Josh Berkus @ 2001-01-16 03:10 UTC (permalink / raw)
  To: pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Question #4 about PL/PGSQL
  2001-01-16 03:10 Question #4 about PL/PGSQL Josh Berkus <josh@agliodbs.com>
@ 2001-01-16 04:58 ` Tom Lane <tgl@sss.pgh.pa.us>
  2001-01-16 05:10   ` Re: Question #4 about PL/PGSQL Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Tom Lane @ 2001-01-16 04:58 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-sql

"Josh Berkus" <josh@agliodbs.com> 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 try to return.

This is a longstanding deficiency that is fixed by the new function
manager in 7.1.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Question #4 about PL/PGSQL
  2001-01-16 03:10 Question #4 about PL/PGSQL Josh Berkus <josh@agliodbs.com>
  2001-01-16 04:58 ` Re: Question #4 about PL/PGSQL Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-01-16 05:10   ` Josh Berkus <josh@agliodbs.com>
  2001-01-16 06:10     ` Re: Question #4 about PL/PGSQL Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Josh Berkus @ 2001-01-16 05:10 UTC (permalink / raw)
  To: pgsql-sql

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
parameter, but not $3.  It did return the string telling me
it had found nulls, however.

> This is a longstanding deficiency that is fixed by the
> new function
> manager in 7.1.

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.

Would it help if I sent more money?  :-)

-Josh




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Question #4 about PL/PGSQL
  2001-01-16 03:10 Question #4 about PL/PGSQL Josh Berkus <josh@agliodbs.com>
  2001-01-16 04:58 ` Re: Question #4 about PL/PGSQL Tom Lane <tgl@sss.pgh.pa.us>
  2001-01-16 05:10   ` Re: Question #4 about PL/PGSQL Josh Berkus <josh@agliodbs.com>
@ 2001-01-16 06:10     ` Josh Berkus <josh@agliodbs.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Josh Berkus @ 2001-01-16 06:10 UTC (permalink / raw)
  To: pgsql-sql

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, but that's hardly your fault.  Thank you so much
for all of your hard work as our "database engine" guru, and
for staying up late to answer our questions!

-Josh



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2001-01-16 06:10 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-16 03:10 Question #4 about PL/PGSQL Josh Berkus <josh@agliodbs.com>
2001-01-16 04:58 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-01-16 05:10   ` Josh Berkus <josh@agliodbs.com>
2001-01-16 06:10     ` Josh Berkus <josh@agliodbs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox