Re: PostgreSQL - 'SKYLINE OF' clause added! - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: PostgreSQL - 'SKYLINE OF' clause added!
Date
Msg-id 200703061043.45435.josh@agliodbs.com
Whole thread Raw
In response to Re: PostgreSQL - 'SKYLINE OF' clause added!  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PostgreSQL - 'SKYLINE OF' clause added!  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Tom,

> I'm also kind of wondering if the main use-cases couldn't be met with
> suitable multi-input custom aggregates, which is something we already
> have as of 8.2.

Actually, given that "skyline of" is *only* for aggregate sorting (as far as I 
can tell) it doesn't present the complications which QBE did for using a 
function interface.   

Ranbeer, would it be possible to use an aggregate function syntax instead of 
the SKYLINE OF syntax extension?   This allows us to sidestep the issue of 
non-standard additions to the reserved word list.

-- 
Josh Berkus
PostgreSQL @ Sun
San Francisco


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Auto creation of Partitions
Next
From: Josh Berkus
Date:
Subject: Re: Auto creation of Partitions