public inbox for [email protected]
help / color / mirror / Atom feedRe: Some developer FAQ links need updating
13+ messages / 7 participants
[nested] [flat]
* Re: Some developer FAQ links need updating
@ 2004-10-14 21:19 Bruce Momjian <[email protected]>
0 siblings, 2 replies; 13+ messages in thread
From: Bruce Momjian @ 2004-10-14 21:19 UTC (permalink / raw)
To: Troels Arvin <[email protected]>; +Cc: pgsql-docs
Thanks. I have updated it to:
1.12) Where can I get a copy of the SQL standards?
There are two major standards, SQL92 and SQL99. These standards are
endorsed by ANSI and ISO. A draft of the SQL92 standard is available at
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt. A draft of
the SQL99 standard is at
http://www.cse.iitb.ac.in/dbms/Data/Papers-Other/SQL1999/ansi-iso-9075-2-1999.pdf.
The draft SQL 2003 standard is at
http://www.wiscorp.com/sql/sql_2003_standard.zip
Some SQL standards web pages are:
* http://troels.arvin.dk/db/rdbms/links/#standards
* http://www.wiscorp.com/SQLStandards.html
* http://www.contrib.andrew.cmu.edu/~shadow/sql.html#syntax (SQL92)
* http://dbs.uni-leipzig.de/en/lokal/standards.pdf (paper)
Also the Developer FAQ link on the developers page was out of date but
has just been fixed.
---------------------------------------------------------------------------
Troels Arvin wrote:
> Hello Bruce,
>
> About http://developer.postgresql.org/readtext.php?src/FAQ/FAQ_DEV.html
> +Developers-FAQ#1.12 :
>
> The section's first link could be more direct:
> http://www.contrib.andrew.cmu.edu/~shadow/sql.html#syntax
>
> The sqlstandards.org FTP-sites seems to be either down (some of the
> time) or password-demanding (the rest of the time). I suggest that you
> link to http://www.wiscorp.com/SQLStandards.html or
> http://troels.arvin.dk/db/rdbms/links/#standards instead.
>
> The http://db.konkuk.ac.kr/present/SQL3.pdf link has 404ed. I suggest
> adding http://www.acm.org/sigmod/record/issues/0403/index.html#standards
> instead.
>
> --
> Greetings from Troels Arvin, Copenhagen, Denmark
>
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Some developer FAQ links need updating
@ 2004-10-14 21:27 Alvaro Herrera <[email protected]>
parent: Bruce Momjian <[email protected]>
1 sibling, 0 replies; 13+ messages in thread
From: Alvaro Herrera @ 2004-10-14 21:27 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: Troels Arvin <[email protected]>; pgsql-docs
On Thu, Oct 14, 2004 at 05:19:13PM -0400, Bruce Momjian wrote:
>
> Thanks. I have updated it to:
>
> 1.12) Where can I get a copy of the SQL standards?
>
> There are two major standards, SQL92 and SQL99.
Ah, shouldn't this say "there are three major ..." if you are going to
give URLs for sql2003 ?
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La soledad es compañía"
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Some developer FAQ links need updating
@ 2004-10-14 21:30 Troels Arvin <[email protected]>
parent: Bruce Momjian <[email protected]>
1 sibling, 1 reply; 13+ messages in thread
From: Troels Arvin @ 2004-10-14 21:30 UTC (permalink / raw)
To: pgsql-docs
Hello Bruce,
On Thu, 2004-10-14 at 17:19 -0400, Bruce Momjian wrote:
> I have updated it to:
>
> 1.12) Where can I get a copy of the SQL standards?
> [...]
Great.
> There are two major standards, SQL92 and SQL99.
Shouldn't that be SQL-92 and SQL:2003, by the way? (SQL:2003 was
ratified early 2004.)
--
Greetings from Troels Arvin, Copenhagen, Denmark
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Some developer FAQ links need updating
@ 2004-10-14 21:49 Bruce Momjian <[email protected]>
parent: Troels Arvin <[email protected]>
0 siblings, 1 reply; 13+ messages in thread
From: Bruce Momjian @ 2004-10-14 21:49 UTC (permalink / raw)
To: Troels Arvin <[email protected]>; +Cc: pgsql-docs
Troels Arvin wrote:
> Hello Bruce,
>
> On Thu, 2004-10-14 at 17:19 -0400, Bruce Momjian wrote:
> > I have updated it to:
> >
> > 1.12) Where can I get a copy of the SQL standards?
> > [...]
>
> Great.
>
> > There are two major standards, SQL92 and SQL99.
>
> Shouldn't that be SQL-92 and SQL:2003, by the way? (SQL:2003 was
> ratified early 2004.)
Updated. I wasn't aware SQL:2003 was ratified.
New text is:
1.12) Where can I get a copy of the SQL standards?
There are three major standards: SQL-92, SQL:1999, and SQL:2003.
These standards are endorsed by ANSI and ISO. Draft
versions can be download from:
* SQL-92 http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
* SQL:1999 http://www.cse.iitb.ac.in/dbms/Data/Papers-Other/SQL1999/ansi-iso-9075-2-1999.pdf
* SQL:2003 http://www.wiscorp.com/sql/sql_2003_standard.zip
Some SQL standards web pages are:
* http://troels.arvin.dk/db/rdbms/links/#standards
* http://www.wiscorp.com/SQLStandards.html
* http://www.contrib.andrew.cmu.edu/~shadow/sql.html#syntax (SQL-92)
* http://dbs.uni-leipzig.de/en/lokal/standards.pdf (paper)
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Some developer FAQ links need updating
@ 2004-10-14 22:19 Peter Eisentraut <[email protected]>
parent: Bruce Momjian <[email protected]>
0 siblings, 1 reply; 13+ messages in thread
From: Peter Eisentraut @ 2004-10-14 22:19 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; Troels Arvin <[email protected]>; +Cc: pgsql-docs
Bruce Momjian wrote:
> There are three major standards: SQL-92, SQL:1999, and SQL:2003.
Actually, they are just different versions of the single major standard.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Some developer FAQ links need updating
@ 2004-10-14 22:31 Bruce Momjian <[email protected]>
parent: Peter Eisentraut <[email protected]>
0 siblings, 1 reply; 13+ messages in thread
From: Bruce Momjian @ 2004-10-14 22:31 UTC (permalink / raw)
To: Peter Eisentraut <[email protected]>; +Cc: Troels Arvin <[email protected]>; pgsql-docs
Peter Eisentraut wrote:
> Bruce Momjian wrote:
> > There are three major standards: SQL-92, SQL:1999, and SQL:2003.
>
> Actually, they are just different versions of the single major standard.
Wording suggestion?
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Some developer FAQ links need updating
@ 2004-10-15 01:36 Joshua D. Drake <[email protected]>
parent: Bruce Momjian <[email protected]>
0 siblings, 2 replies; 13+ messages in thread
From: Joshua D. Drake @ 2004-10-15 01:36 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: Peter Eisentraut <[email protected]>; Troels Arvin <[email protected]>; pgsql-docs
Bruce Momjian wrote:
>Peter Eisentraut wrote:
>
>
>>Bruce Momjian wrote:
>>
>>
>>> There are three major standards: SQL-92, SQL:1999, and SQL:2003.
>>>
>>>
>>Actually, they are just different versions of the single major standard.
>>
>>
>
>Wording suggestion?
>
>
There is only one current standard SQL:2003 correct? The rest are
considered deprecated?
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - [email protected] - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Some developer FAQ links need updating
@ 2004-10-15 03:24 Bruce Momjian <[email protected]>
parent: Joshua D. Drake <[email protected]>
1 sibling, 1 reply; 13+ messages in thread
From: Bruce Momjian @ 2004-10-15 03:24 UTC (permalink / raw)
To: Joshua D. Drake <[email protected]>; +Cc: Peter Eisentraut <[email protected]>; Troels Arvin <[email protected]>; pgsql-docs
Joshua D. Drake wrote:
> Bruce Momjian wrote:
>
> >Peter Eisentraut wrote:
> >
> >
> >>Bruce Momjian wrote:
> >>
> >>
> >>> There are three major standards: SQL-92, SQL:1999, and SQL:2003.
> >>>
> >>>
> >>Actually, they are just different versions of the single major standard.
> >>
> >>
> >
> >Wording suggestion?
> >
> >
>
> There is only one current standard SQL:2003 correct? The rest are
> considered deprecated?
I don't think so. Some database say they are SQL99-compliant while not
SQL-2003 compliant.
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Some developer FAQ links need updating
@ 2004-10-15 12:09 Peter Eisentraut <[email protected]>
parent: Bruce Momjian <[email protected]>
0 siblings, 2 replies; 13+ messages in thread
From: Peter Eisentraut @ 2004-10-15 12:09 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: Joshua D. Drake <[email protected]>; Troels Arvin <[email protected]>; pgsql-docs
Am Freitag, 15. Oktober 2004 05:24 schrieb Bruce Momjian:
> I don't think so. Some database say they are SQL99-compliant while not
> SQL-2003 compliant.
Clearly, consenting parties are free to agree on making their products conform
to any standards document, be it old or new or deprecated or silly. In the
same way, someone could make a product that is certified for PostgreSQL
7.2.1. Or someone could write an HTML-compliant browser, only that it might
be HTML 3.2.
Since we have limited resources, I think it's OK that we concentrate on
working with the latest official standards version. And because the latest
standards version is modularized and has individual feature lists and
packages, it would be a lot easier for us to look good, and it would be more
useful for users to, say, specify a workable set of requirements for their
applications.
Nevertheless, it would surely be useful to list SQL92 and SQL99 as older
versions, just like many people still code to HTML 4.01 instead of XHTML 1.1,
and just like many people still use PostgreSQL 7.2.1, inspite of it not
conforming to any standard, as far as I know.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Some developer FAQ links need updating
@ 2004-10-15 16:10 Bruce Momjian <[email protected]>
parent: Peter Eisentraut <[email protected]>
1 sibling, 0 replies; 13+ messages in thread
From: Bruce Momjian @ 2004-10-15 16:10 UTC (permalink / raw)
To: Peter Eisentraut <[email protected]>; +Cc: Joshua D. Drake <[email protected]>; Troels Arvin <[email protected]>; pgsql-docs
OK, new wording:
<P>There are three versions of the SQL standard: SQL-92, SQL:1999,
and SQL:2003. They are endorsed by ANSI and ISO. Draft versions
can be download from:
---------------------------------------------------------------------------
Peter Eisentraut wrote:
> Am Freitag, 15. Oktober 2004 05:24 schrieb Bruce Momjian:
> > I don't think so. Some database say they are SQL99-compliant while not
> > SQL-2003 compliant.
>
> Clearly, consenting parties are free to agree on making their products conform
> to any standards document, be it old or new or deprecated or silly. In the
> same way, someone could make a product that is certified for PostgreSQL
> 7.2.1. Or someone could write an HTML-compliant browser, only that it might
> be HTML 3.2.
>
> Since we have limited resources, I think it's OK that we concentrate on
> working with the latest official standards version. And because the latest
> standards version is modularized and has individual feature lists and
> packages, it would be a lot easier for us to look good, and it would be more
> useful for users to, say, specify a workable set of requirements for their
> applications.
>
> Nevertheless, it would surely be useful to list SQL92 and SQL99 as older
> versions, just like many people still code to HTML 4.01 instead of XHTML 1.1,
> and just like many people still use PostgreSQL 7.2.1, inspite of it not
> conforming to any standard, as far as I know.
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Some developer FAQ links need updating
@ 2004-10-15 16:19 Josh Berkus <[email protected]>
parent: Peter Eisentraut <[email protected]>
1 sibling, 0 replies; 13+ messages in thread
From: Josh Berkus @ 2004-10-15 16:19 UTC (permalink / raw)
To: Peter Eisentraut <[email protected]>; +Cc: Bruce Momjian <[email protected]>; Joshua D. Drake <[email protected]>; Troels Arvin <[email protected]>; pgsql-docs
Peter, Folks:
> Since we have limited resources, I think it's OK that we concentrate on
> working with the latest official standards version. And because the latest
> standards version is modularized and has individual feature lists and
> packages, it would be a lot easier for us to look good, and it would be
> more useful for users to, say, specify a workable set of requirements for
> their applications.
FWIW, there's two standards that application developers are concerned with as
far as I can tell: SQL92, which is the "stable" standard that ensures
cross-database compatibility (as well as the only standard that is readable)
and SQL2003, which is the current standard and ensures buzzowrd-compliance as
well as future prospects.
--
Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Some developer FAQ links need updating
@ 2004-10-15 16:51 Tom Lane <[email protected]>
parent: Joshua D. Drake <[email protected]>
1 sibling, 1 reply; 13+ messages in thread
From: Tom Lane @ 2004-10-15 16:51 UTC (permalink / raw)
To: Joshua D. Drake <[email protected]>; +Cc: Bruce Momjian <[email protected]>; Peter Eisentraut <[email protected]>; Troels Arvin <[email protected]>; pgsql-docs
"Joshua D. Drake" <[email protected]> writes:
> There is only one current standard SQL:2003 correct? The rest are
> considered deprecated?
The old ones are certainly not "deprecated".
Personally I find the newer versions to be suffering from uncontrolled
feature bloat and committee-itis.
regards, tom lane
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Some developer FAQ links need updating
@ 2004-10-15 16:53 Bruce Momjian <[email protected]>
parent: Tom Lane <[email protected]>
0 siblings, 0 replies; 13+ messages in thread
From: Bruce Momjian @ 2004-10-15 16:53 UTC (permalink / raw)
To: Tom Lane <[email protected]>; +Cc: Joshua D. Drake <[email protected]>; Peter Eisentraut <[email protected]>; Troels Arvin <[email protected]>; pgsql-docs
Tom Lane wrote:
> "Joshua D. Drake" <[email protected]> writes:
> > There is only one current standard SQL:2003 correct? The rest are
> > considered deprecated?
>
> The old ones are certainly not "deprecated".
>
> Personally I find the newer versions to be suffering from uncontrolled
> feature bloat and committee-itis.
That was my feeling too. I know many cases the older specifications
were clearer.
Anyway, I think the new "There are three versions of the SQL standard"
wording is OK.
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2004-10-15 16:53 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-14 21:19 Re: Some developer FAQ links need updating Bruce Momjian <[email protected]>
2004-10-14 21:27 ` Alvaro Herrera <[email protected]>
2004-10-14 21:30 ` Troels Arvin <[email protected]>
2004-10-14 21:49 ` Bruce Momjian <[email protected]>
2004-10-14 22:19 ` Peter Eisentraut <[email protected]>
2004-10-14 22:31 ` Bruce Momjian <[email protected]>
2004-10-15 01:36 ` Joshua D. Drake <[email protected]>
2004-10-15 03:24 ` Bruce Momjian <[email protected]>
2004-10-15 12:09 ` Peter Eisentraut <[email protected]>
2004-10-15 16:10 ` Bruce Momjian <[email protected]>
2004-10-15 16:19 ` Josh Berkus <[email protected]>
2004-10-15 16:51 ` Tom Lane <[email protected]>
2004-10-15 16:53 ` Bruce Momjian <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox