Re: Details of string operations

On 2010-12-05, at 18:04, Andy Seaborne wrote:
> 
> On 05/12/10 15:47, Steve Harris wrote:
>>>> CONCAT(plain, anything) ->  plain
>>>> >>  CONCAT(string, string) ->  string
>>> >
>>> >  CONCAT(simple, anything) ->  anything
>> But if CONCAT(plain, string) gives plain, you don't need that case, it falls out naturally as "simple" literals are a subset of plain.
> 
> 
> For me, it's whether the result follows the data or the query form and I'd rather it followed the data.  Not following the form of the data seems to more inconsistent and inconvenient.

Ah, I see. That makes a certain amount of sense.

I still prefer the other way, as I think it's cleaner / simpler / less confusing.

- Steve

-- 
Steve Harris, CTO, Garlik Limited
1-3 Halford Road, Richmond, TW10 6AW, UK
+44 20 8439 8203  http://www.garlik.com/
Registered in England and Wales 535 7233 VAT # 849 0517 11
Registered office: Thames House, Portsmouth Road, Esher, Surrey, KT10 9AD

Received on Monday, 6 December 2010 12:22:31 UTC