enum types and binary queries

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема enum types and binary queries
Дата
Msg-id b42b73150708301013y58eb976bi38dc8acb3471a603@mail.gmail.com
обсуждение исходный текст
Ответы Re: enum types and binary queries
Re: enum types and binary queries
Список pgsql-hackers
I noticed that enums are not available to be queried as binary through
the protocol.  Is this a known issue?  Too late to fix for 8.3?  This
is kind of a pain, because it forces any query that returns an enum to
return the entire result as text.  afaik, enums are the only POD type
to behave this way.

postgres=# create type foo as enum('foo');
CREATE TYPE

postgres=# copy (select 'foo'::foo) to '/home/postgres/foo.txt' binary;
ERROR:  no binary output function available for type foo

merlin


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

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: tsearch2, gin and @@@ operator?
Следующее
От: Ron Mayer
Дата:
Сообщение: Re: Why is there a tsquery data type?