From: | casey(at)cloudera(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #11825: "select lead('literal text') ..." -> could not determine polymorphic type |
Date: | 2014-10-29 21:45:31 |
Message-ID: | 20141029214531.6149.49378@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 11825
Logged by: casey
Email address: casey(at)cloudera(dot)com
PostgreSQL version: 9.3.5
Operating system: ubuntu 14.04
Description:
Some analytic functions such as LEAD/FIRST_VALUE don't accept char literals
as input, an example is below. This came up randomly during some testing. I
don't have a good use case for such a query and it's easy to workaround but
it seems odd so I thought I'd report it.
functional=# select version();
version
------------------------------------------------------------------------------------------------------
PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu
4.8.2-19ubuntu1) 4.8.2, 64-bit
(1 row)
functional=# create table empty (c int);
CREATE TABLE
functional=# SELECT LEAD('a') OVER () FROM empty;
ERROR: could not determine polymorphic type because input has type
"unknown"
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-10-29 22:15:59 | Re: BUG #11638: Transaction safety fails when constraints are dropped and analyze is done |
Previous Message | skeefe | 2014-10-29 19:27:58 | BUG #11824: Postgres Restoring the same file multiple times |