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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David Pinheiro" <davidsantospinheiro(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5836: Enum Support Functions don't work on empty tables
Date: 2011-01-13 18:43:23
Message-ID: 20574.1294944203@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"David Pinheiro" <davidsantospinheiro(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message frank 2011-01-14 00:14:21 Re: BUG #5816: index not used in function
Previous Message Tom Lane 2011-01-13 18:09:42 Re: BUG #5834: Planner - cost for hash scan too small