Re: "ERROR: operator is not unique" with Custom Data Type

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(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.