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

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: "ERROR: operator is not unique" with Custom Data Type
Дата
Msg-id 20080605210732.GF16690@svana.org
обсуждение исходный текст
Ответ на Re: "ERROR: operator is not unique" with Custom Data Type  ("David E. Wheeler" <david@kineticode.com>)
Ответы Re: "ERROR: operator is not unique" with Custom Data Type
Список 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 по дате отправления:

Предыдущее
От: Ron Mayer
Дата:
Сообщение: Re: Overhauling GUCS
Следующее
От: Aidan Van Dyk
Дата:
Сообщение: Re: Overhauling GUCS