On Jun 5, 2008, at 14:07, Martijn van Oosterhout wrote:

I'm sure I'm missing something simple here. How do I make it assignment?

# \h create cast
Command:     CREATE CAST
Description: define a new cast
Syntax:
<snip>
CREATE CAST (sourcetype AS targettype)
   WITHOUT FUNCTION
   [ AS ASSIGNMENT | AS IMPLICIT ]

I need to read up on the CAST documentation. Thanks.

Huh. That's what citext has, too:

CREATE CAST (citext AS text) WITHOUT FUNCTION AS IMPLICIT;
CREATE CAST (text AS citext) WITHOUT FUNCTION AS IMPLICIT;

And citext probably doesn't work with 8.3? The casting rules wrt text
have changed...

Yes, that is correct. It builds, but the SQL doesn't all run properly. I'll be wading through all those failures once I get the basics worked out with v2.

Thanks,

David


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to