Bruno Wolff III wrote: > 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. > Indeed. I stand corrected. I use the two in my query, guess I just mixed them up :-) My apologies. Stijn Vanroye ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
