Alvaro Herrera <alvherre(at)commandprompt(dot)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
In response to
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 2008-12-31 16:22:50|
|Subject: Re: version() output vs. 32/64 bits|
|Previous:||From: Tom Lane||Date: 2008-12-31 16:01:25|
|Subject: Re: pg_pltemplate entries for external PLs |