"Keith Worthington" <keithw(at)narrowpathinc(dot)com> writes:
> IPADB=# SELECT CAST(scan_date || scan_time AS timestamp) AS datetime_timestamp
> FROM data_transfer.tbl_inventory_scanner;
> ERROR: Cannot cast type character to timestamp without time zone
> IPADB=# SELECT employee_id, item_id, CAST(quantity AS float4) AS quantity FROM
> data_transfer.tbl_inventory_scanner;
> ERROR: Cannot cast type character varying to real
Try casting the inputs to type "text" and then to timestamp or real.
regards, tom lane