BUG #5836: Enum Support Functions don't work on empty tables - Mailing list pgsql-bugs

From David Pinheiro
Subject BUG #5836: Enum Support Functions don't work on empty tables
Date
Msg-id 201101131733.p0DHXBWs056451@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5836: Enum Support Functions don't work on empty tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5834: Planner - cost for hash scan too small
Next
From: Tom Lane
Date:
Subject: Re: BUG #5836: Enum Support Functions don't work on empty tables