Re: PostgreSQL - 'SKYLINE OF' clause added!

From: Shane Ambler <pgsql(at)Sheeky(dot)Biz>
To: Naz Gassiep <naz(at)mira(dot)net>
Cc: Nikita <nikita(dot)p(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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:20:04
Message-ID: 45F4C6E4.40407@Sheeky.Biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Naz Gassiep wrote:

> Let us not do the same to
> SQL and implement SKYLINE on our own, only to have other DBMS vendors
> implement it in different ways and then finally when the SQL standard
> includes it they try to make some kind of average approximation of the
> implementations resulting in *none* of the DBs being compliant. Then
> we'll be between the rock of breaking backwards compatibility and the
> hard place of unwarranted standards non-compliance.
>
> While Josh did point out that being in the leading group as far as
> implementing new functionality goes, I feel that it has to be weighed
> against the need to not strike out too aggressively, potentially
> isolating ourselves with excessive non-standard syntax or behavior.
>
> While I am convinced there is a strong use case for this functionality
> and we should definitely start looking at it, I don't see why we should
> be in a rush to get it into core. People have survived without it up to
> now, I don't think our userbase will suffer if it is implemented 6
> months after <foo commercial DB> implements it, at least, not as much as
> it will suffer if we start drifting away from standards compliance.

And where did most of the SQL standard come from? A lot of it copies or
is based on either the first db to implement a feature or the one to
implement the best syntax.

And how much of the standard became standard because most of the db's
had already implemented similar features?

Some things can syntactically be expressed more than one way, while
others are limited in ways to coherently express what you want to achieve.

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.

--

Shane Ambler
pgSQL(at)Sheeky(dot)Biz

Get Sheeky @ http://Sheeky.Biz

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-03-12 03:44:41 Re: PostgreSQL - 'SKYLINE OF' clause added!
Previous Message Tom Lane 2007-03-12 02:53:19 Re: Why is "osprey" dumping core in REL8_2 branch?