Keith Worthington <KeithW(at)NarrowPathInc(dot)com> writes:
> Tom Lane wrote:
>> Try casting the inputs to type "text" and then to timestamp or real.
> Are you saying that I should try something like
> CAST( CAST( quantity AS text ) AS float4) AS quantity
Right. (In the cases where you were concatenating, do that inside the
first cast.)
BTW, Postgres hackers would tend to write the above as
quantity::text::float4
which is not SQL-spec notation but sure saves a lot of typing.
regards, tom lane