Skip site navigation (1) Skip section navigation (2)

Re: SQL99

From: "Jason Watkins" <jason_watkins(at)pobox(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: SQL99
Date: 2001-10-30 00:04:36
Message-ID: 008d01c160d6$76a7a290$426f2a40@boondocksaint (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
You should worry about whether your chosen DBMS will support the necessary
features for your application.

You should not worry about whether it meets a checklist requirement of
SQL99, to my knowledge no database, commercial or otherwise, does.

As it happens, Postgre supports a wider portion of the standard than most.
But it's important to realize that nearly all the DMBS's out there support
the same feature and enable the same programming techniques as are stated in
SQL99, just with differing syntax.

In terms of the standard itself, there are vast portions of the extended
standard that vendors have declaired they do not intend to impliment.

A better way to ask this question is: of the features I plan to use for my
application, which databases expose those features with SQL99 syntax? This
is what governs your application being portable.

The SQL99 standard is online. If I recall, it's about 2,000 pages.

> PortgreSQL is implementing full SQL99 specification? In which relase?
> Where can i find further info about ANSI SQL 99 and others DBMS which
> implement SQL 99?
> Thanks in advance!

In response to

  • SQL99 at 2001-10-27 16:38:05 from Valdir H. Dias Leite


  • Re: SQL99 at 2001-10-30 17:01:30 from Jochem van Dieten

pgsql-sql by date

Next:From: Stephan SzaboDate: 2001-10-30 00:07:30
Subject: Re: table permissions
Previous:From: Aasmund Midttun GodalDate: 2001-10-29 23:57:25
Subject: Re: table permissions

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group