> >If you want this behaviour you will have to explicitly handle it with COALESCE(). > >regards, >Lukas
True. But there's a point where oracle is really better here, they named "coalesce" "nvl" => a lot easier to type ;-) ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq