Postgres Pro
Downloads
Home   >   mailing lists

Re: CAST function for user defined type - Mailing list pgsql-general

From Tom Lane
Subject Re: CAST function for user defined type
Date
Msg-id 18606.1169481477@sss.pgh.pa.us
Whole thread Raw
In response to CAST function for user defined type  (Ron Peterson <ron.peterson@yellowbank.com>)
List pgsql-general
Tree view 
Ron Peterson <ron.peterson@yellowbank.com> writes:
> I've created my own type: y_octet_16.  Now I'm trying to create a CAST
                            ^^^^^^^^^^

> % INSERT INTO bt( name, val ) VALUES
>   ( 'aaa', encode( y_uuid_generate(), 'hex' )::y_byte_16 );
> ERROR:  type "y_byte_16" does not exist
                ^^^^^^^^^

Are you sure this isn't just pilot error?

            regards, tom lane

pgsql-general by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: [HACKERS] Autovacuum Improvements
Next
From: Robert Fitzpatrick
Date:
Subject: MSSQL/ASP migration