Re: [TF-LIB] COALESCE is an unhelpful choice of name

On Fri, Nov 13, 2009 at 6:59 PM, Steve Harris <> wrote:
> On 13 Nov 2009, at 13:01, Andy Seaborne wrote:
>> I don't find the name COALESCE very helpful.
>> None of these seem good but they are better to me:
>> VAL
> None of these float my boat, but out of interest, what's the source of your
> dislike for COALESCE? I find it pretty obvious, but then I've been using SQL
> for too long.

Personally, I'd never heard of this function, and it's been completely
opaque to me. I've come back to it a few times now (each time after a
break of a couple of weeks) and every time I've had to look up some
documentation to remind myself of what it meant.

But then, I haven't used SQL much in recent years.

Paul Gearon

Received on Saturday, 14 November 2009 00:06:24 UTC