Re: PostgreSQL - 'SKYLINE OF' clause added!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Shane Ambler <pgsql(at)Sheeky(dot)Biz>
Cc: Naz Gassiep <naz(at)mira(dot)net>, Nikita <nikita(dot)p(at)gmail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org, Gavin Sherry <swm(at)alcove(dot)com(dot)au>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Chris Browne <cbbrowne(at)acm(dot)org>
Subject: Re: PostgreSQL - 'SKYLINE OF' clause added!
Date: 2007-03-12 03:44:41
Message-ID: 28816.1173671081@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Shane Ambler <pgsql(at)Sheeky(dot)Biz> writes:
> If we consider this thoroughly and compile a suitable syntax that covers
> all bases it could be used as the basis of the standard definition or be
> close to what ends up in the standard.

I'll bet you a very good dinner that the word SKYLINE will never be seen
in the standard.

To me, the proposed feature seems an extremely narrow, special-purpose
thing. The SQL committee have never been into that very much, and seem
even less interested in the last couple of revisions. They like
mechanisms that can be used to solve a wide variety of problems, and
are not afraid to introduce conceptual complexity to get there.
Two examples for you: outer joins and recursive queries. Oracle's
(+) syntax is more compact than what got into the spec, but less
precise and less functional. For recursive queries, CONNECT BY is
way simpler than what got into the spec, but again doesn't cover as
much ground. The SKYLINE clause seems to me to be right about on
par with CONNECT BY ... it does something useful, but only one thing.

I think the challenge for the SKYLINE authors is to recast what they did
as a general feature --- something feeling like, say, multi-argument
aggregates or window functions. The mechanisms that they want to put
into the executor sound like they can do a whole lot more than SKYLINE;
find a way to expose that power. And the fewer bespoke keywords needed,
the better ;-)

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message ITAGAKI Takahiro 2007-03-12 07:21:25 Re: Bug: Buffer cache is not scan resistant
Previous Message Shane Ambler 2007-03-12 03:20:04 Re: PostgreSQL - 'SKYLINE OF' clause added!