Subject Re: constants interpreted as char instead of varchar
Author woodsmailbox
--- In, "woodsmailbox" <cosmin.apreutesei@...> wrote:
> is there any shortcut to make 'x' a varchar instead of char in sql
> expressions? for instance,
> decode(1 = 1, 'a', 'ab')||'c'
> returns 'a c' instead of the more intuitive 'ac'... casting all
> constants to varchar makes expressions unreadable. if beating up a
> dead horse, then sorry for the noise.

Should I make a request on the tracker? That is, if the holy standard allows it, of course :)