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