Subject | Re: constants interpreted as char instead of varchar |
---|---|
Author | woodsmailbox |
Post date | 2009-03-03T19:07:26Z |
> What about casting the decode result? Like:varchar('a ') is still 'a '
>
> cast(decode(1 = 1, 'a', 'ab') as varchar(2)) || 'c'
>
trim(decode)||'c' works, but nested decodes get so cluttered... and
it's still painfully not-like-any-other-language, a source of bugs for
me.