> select ltrim(first_name) || (' ' || ltrim(last_name)) as full_name
> from
> ...
>
> where "ltrim" is used only to convert both, first_time and
> last_time, to text. I wish I could convert among string types
> (bpchar, varchar and text) without any tricks, but it seems this
> is not implemented yet.
>
Ever tried the cast() function?
-DEJ