On Thu, Jan 25, 2001 at 10:01:21AM +0200, Esa Pikkarainen <[EMAIL PROTECTED]> wrote: > Thank you very much. Fine! Just two little questiton s more: > > 1) Can COALESCE take more than two alternatives? > > 2) Does it treat a zero length string as NULL or NOT NULL? Wouldn't it have been faster to fire up psql and try a select to see what the answer is than send a message to this list? COALESCE definitely works with more than 2 values, as I use it that way. '' should not be the same as a null, but I haven't actually tested this to make sure it works that way.