Re: PL/PgSQL and NULL

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Andrew Perrin <aperrin(at)socrates(dot)berkeley(dot)edu>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: PL/PgSQL and NULL
Date: 2001-03-11 21:38:10
Message-ID: Pine.LNX.4.30.0103112237250.809-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Andrew Perrin writes:

> I'm trying to write what should be a simple function that returns the
> minimim of two integers. The complication is that when one of the two
> integers is NULL, it should return the other; and when both are NULL, it
> should return NULL.

Functions involving NULLs don't work well before version 7.1.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ross J. Reedstrom 2001-03-11 22:19:20 Re: PL/PgSQL and NULL
Previous Message Andrew Perrin 2001-03-11 20:38:13 PL/PgSQL and NULL