Postgres Pro
Downloads
Home   >   mailing lists

CAST ON NEW TYPE - Mailing list pgsql-hackers

From
Subject CAST ON NEW TYPE
Date
Msg-id 200012061503.eB6F3wt25942@mail.postgresql.org
Whole thread Raw
Responses Re: CAST ON NEW TYPE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Hi,

I create a new type that work well, but when
i use the cast function on my new type like this i have an error:
(other fucntion like substring don't work too )

select bare_code::text from ean_article;
ERROR:  Cannot cast type 'ean13' to 'text'

What can i do in my new type in order to use cast ???

Best regards,

PEJAC Pascal

pgsql-hackers by date:

Previous
From: Felix Lungu
Date:
Subject: BLOB Help!
Next
From: Camm Maguire
Date:
Subject: Re: Foreign key references to non-primary key columns