Alvaro Herrera <alvhe...@commandprompt.com> writes:
> Heikki Linnakangas escribió:
>> Tom Lane wrote:
>>> pg_catalog | nth_value | anyelement | anyelement, integer OVER window
>>
>> That looks like "OVER window" is associated with the "integer", like
>> DEFAULT. I don't have any better suggestions, though.
> pg_catalog | nth_value | anyelement | (anyelement, integer) OVER
> window
Yeah, I had considered that too, and it has a distinct advantage for
parameterless functions like rank():
Schema | Name | Result data type | Argument data types
------------+------+------------------+---------------------
pg_catalog | rank | bigint | OVER window
pg_catalog | rank | bigint | () OVER window
The latter is definitely clearer about what you're supposed to do.
However, it seems kind of inconsistent to do this for window functions
unless we also make \df start putting parens around the argument lists
for regular functions. Comments?
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
