| From: | Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Daniel Schuchardt <daniel_schuchardt(at)web(dot)de>, <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Re: plpgsql NULL statement (was Re: [GENERAL] Postgres |
| Date: | 2004-08-16 06:43:05 |
| Message-ID: | Pine.LNX.4.44.0408160840380.9559-100000@zigo.dhs.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Reko Turja | 2004-08-16 06:59:49 | Re: postgres in freebsd jail |
| Previous Message | Vikram | 2004-08-16 05:53:50 | postgres in freebsd jail |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karel Zak | 2004-08-16 07:45:43 | Re: to_char() and negative intervals |
| Previous Message | Andrew Dunstan | 2004-08-16 05:38:42 | Re: plpgsql NULL statement (was Re: [GENERAL] Postgres 8.0 -> BEGIN EXCEPTION END Syntax????) |