Re: "ERROR: operator is not unique" with Custom Data Type - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: "ERROR: operator is not unique" with Custom Data Type
Date
Msg-id 20080605210732.GF16690@svana.org
Whole thread Raw
In response to Re: "ERROR: operator is not unique" with Custom Data Type  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: "ERROR: operator is not unique" with Custom Data Type  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-hackers
On Thu, Jun 05, 2008 at 11:37:28AM -0700, David E. Wheeler wrote:
> >Whichever way
> >you want it, make that direction implicit and the other direction
> >assignment.
>
> 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 ]

> 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...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

pgsql-hackers by date:

Previous
From: Ron Mayer
Date:
Subject: Re: Overhauling GUCS
Next
From: Aidan Van Dyk
Date:
Subject: Re: Overhauling GUCS