Re: plpgsql NULL statement (was Re: [GENERAL] Postgres - Mailing list pgsql-hackers

From Dennis Bjorklund
Subject Re: plpgsql NULL statement (was Re: [GENERAL] Postgres
Date
Msg-id Pine.LNX.4.44.0408160840380.9559-100000@zigo.dhs.org
Whole thread Raw
In response to plpgsql NULL statement (was Re: [GENERAL] Postgres 8.0 -> BEGIN EXCEPTION END Syntax????)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: plpgsql NULL statement (was Re: [GENERAL] Postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mon, 16 Aug 2004, Tom Lane wrote:

> > in oracle it's
> > WHEN OTHERS THEN null;
> > but this syntax doesn't work in postgres.
> 
> It looks like about five minutes' work to add such a thing ... anyone
> have any objections?

Is NULL above an empty statement in oracle or is it a normal expression
(the normal NULL value) so that the above is a shorthand for
  WHEN OTHERS THEN SELECT NULL;

?

-- 
/Dennis Björklund



pgsql-hackers by date:

Previous
From: "Andrew Dunstan"
Date:
Subject: Re: plpgsql NULL statement (was Re: [GENERAL] Postgres 8.0 -> BEGIN EXCEPTION END Syntax????)
Next
From: Karel Zak
Date:
Subject: Re: to_char() and negative intervals