BUG #5836: Enum Support Functions don't work on empty tables

Поиск
Список
Период
Сортировка
От David Pinheiro
Тема BUG #5836: Enum Support Functions don't work on empty tables
Дата
Msg-id 201101131733.p0DHXBWs056451@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5836: Enum Support Functions don't work on empty tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      5836
Logged by:          David Pinheiro
Email address:      davidsantospinheiro@gmail.com
PostgreSQL version: 8.4
Operating system:   Centos
Description:        Enum Support Functions don't work on empty tables
Details:

The functions referred on Table 9-29 in
http://www.postgresql.org/docs/9.0/static/functions-enum.html don't work on
empty tables.

Example: If you have an empty table and you query:
SELECT enum_range("enum_table_column") from "table_name";
postgres returns an empty result.
If the table has some element, the query works ok.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5834: Planner - cost for hash scan too small
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5836: Enum Support Functions don't work on empty tables