BUG #5836: Enum Support Functions don't work on empty tables
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.
"David Pinheiro" <davidsantospinheiro@gmail.com> writes:
Example: If you have an empty table and you query:
SELECT enum_range("enum_table_column") from "table_name";
postgres returns an empty result.
That doesn't seem like a bug. No rows in, no rows out.
regards, tom lane