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

Поиск
Список
Период
Сортировка
От Larry Rosenman
Тема Followup from yesterday's PL/pgSQL fun...
Дата
Msg-id 177190000.1052930499@lerlaptop-red.iadfw.net
обсуждение исходный текст
Ответы Re: Followup from yesterday's PL/pgSQL fun...
Список pgsql-sql
I posted:

Also, this is what I wound up with for that line, which seems ugly, because
it couldn't find a quote_literal(inet) without the ::text on it:
 quote_literal(NEW.netblock::inet::text) ;


Is that right?



Can I ask 3 questions:

1) should quote_literal find a ::text conversion on it's own?
2) can text(cidr) be added to the default pg_cast table?
3) how can I add text(cidr) myself?



-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749





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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Type coercion on column in a query
Следующее
От: Luis Sousa
Дата:
Сообщение: Re: Can arrays reference primary keys in CREATE TABLE?