On Fri, Apr 23, 2004 at 13:07:43 +0200, Stijn Vanroye <s.vanroye@farcourier.com> wrote: > Maybe you can do something with this function: > > [quote from the postgres docs] > 9.12.2. COALESCE > COALESCE(value [, ...]) That's the inverse of what he would want if he used that approach. NULLIF is what turns things into NULLs. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly