Bug reference: 4362
Logged by: Andrej Podzimek
Email address: firstname.lastname@example.org
PostgreSQL version: 8.3
Operating system: Linux
Description: Casts from base types to composite types don't work.
CREATE TYPE pxgt_xid AS (xid bigint, xname text);
CREATE FUNCTION pxgt_xid(text) RETURNS pxgt_xid AS
$BODY$ select cast ( null as bigint ), $1; $BODY$
LANGUAGE 'sql' IMMUTABLE;
CREATE CAST (text AS pxgt_xid) WITH FUNCTION pxgt_xid(bigint) AS IMPLICIT;
select cast (text 'blabla' as pxgt_xid);
ERROR: malformed record literal: "blabla"
DETAIL: Missing left parenthesis.
When I create a similar cast for bigint->pxgt_xid, it seems to work. But in
fact an implicit cast works here, not the defined one... So as long as the
first field is a bigint, a default cast is used and the second field is just
set to null automatically. So implicit casts bigint->pxgt_xid and
(bigint)->pxgt_xid (with bigint in a simple record) work fine. But the cast
defined above is simply ignored.
AFAIK, the documentation does not mention that casts between base and
composite types are discouraged, prohibited or impossible.
Theoretically, it should be possible to create a function that accepts the
type pxgt_xid, which contains either a text or a numeric identifier. By
adding just one "is null" condition, one could have the code for both
identifier types in one function, without function overloading. That would
be great ... if the implicit cast above worked.