Re: Followup from yesterday's PL/pgSQL fun...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Followup from yesterday's PL/pgSQL fun...
Дата
Msg-id 25250.1052931519@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Followup from yesterday's PL/pgSQL fun...  (Larry Rosenman <ler@lerctr.org>)
Ответы Re: Followup from yesterday's PL/pgSQL fun...
Список pgsql-sql
Larry Rosenman <ler@lerctr.org> writes:
> 1) should quote_literal find a ::text conversion on it's own?

It won't, because the pg_cast entry for inet->text is marked "explicit
casts only".  In general I don't like implicit casts across datatype
categories, and am hoping to move in the direction of marking more such
casts as explicit-only.

> 2) can text(cidr) be added to the default pg_cast table?

I'll make that happen for 7.4.

> 3) how can I add text(cidr) myself?

Read the pg_cast description in 
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=catalogs.html
Insert a suitable row.
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: Luis Sousa
Дата:
Сообщение: Re: bad query performance
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Followup from yesterday's PL/pgSQL fun...