Sorry..

Ignore previous half-completed email.

How do you get this to work in 7.2.1?

I'm creating a view of a table, but I'm trying to do something like
this:

create table t (
id integer not null,
amount numeric(7,2)
);

create view v as
select id as v_id,
'paid amount: ' || amount as v_comment
from t
;

You get this:

ERROR: Unable to identify an operator '||' for types 'unknown' and
'numeric'
You will have to retype this query using an explicit cast

None of these work:

CAST(amount AS text)
CAST(amount AS varchar)
CAST(amount AS char)
and this:
CAST(amount AS real) works, but if amount is 12.00, then you just get '12' -
which is not cool.

Any ideas?

Chris