Have you installed the tablefunc extension？
please show the \dx results in psql?
Jov
blog: http:amutu.com/blog <http://amutu.com/blog>
2013/8/19
> The following bug has been logged on the website:
>
> Bug reference: 8386
> Logged by: pradeep
http://postgresql.1045698.n5.nabble.com/BUG-5199-Window-frame-clause-wrong-behaviour-td2131492.html
tody I hit by this bug and can't find any doc about this, after google I
find the bug 5199 reported 4 years ago.
it is really nice to improve the error message or doc.
Jov
blog: http:amut
identifier?*
I have read the doc 4.4.1 and can't find this info from there so I thin it
is a bug.
2013/2/22 Jov
> I have get the description of this behaviour from doc 7.3.2
>
> http://www.postgresql.org/docs/devel/static/queries-select-lists.html#QUERIES-COLUMN-LABELS
> .
&
ery error user can save a lot of time.
>
> Well, yours is the first complaint we've ever had in that direction,
> whereas we used to get a lot of complaints in the opposite direction,
> back when we didn't allow keywords to be used for column names.
> So I doubt we'll change it. It is an interesting gotcha though :-(
>
> regards, tom lane
> .
>
>
--
Jov
blog: http:amutu.com/blog <http://amutu.com/blog>
The following bug has been logged on the website:
Bug reference: 7899
Logged by: jov
Email address: am...@amutu.com
PostgreSQL version: 9.1.3
Operating system: CentOS 6
Description:
xxx=# select 2 from (select 1 as end) t;
?column?
--
2
(1 row
