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


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to