"Andrej Podzimek" <[EMAIL PROTECTED]> writes:
> select cast (text 'blabla' as pxgt_xid);
> ERROR: malformed record literal: "blabla"
> DETAIL: Missing left parenthesis.
Works for me, after fixing the obvious typo in your CREATE CAST command:
regression=# CREATE TYPE pxgt_xid AS (xid bigint, xna
The following bug has been logged online:
Bug reference: 4362
Logged by: Andrej Podzimek
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3
Operating system: Linux
Description:Casts from base types to composite types don't work.
Details:
CREATE TYPE pxgt_xid A