Archives of the TeradataForum
Message Posted: Mon, 03 Jun 2002 @ 14:02:08 GMT
Can anyone explain why in certain circumstances the Teradata parser requires parens around a function call? I have a suspicion that there's an implicit conversion taking place but I don't see why.
select coalesce(null, '123')
select coalesce(null, '123') || 'foo'
select (coalesce(null, '123')) || 'foo'
Ah, the parens make all the difference.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|