pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jason Watkins <jason_watkins@pobox.com>
To: pgsql-sql@postgresql.org
Subject: Re: SQL99
Date: Mon, 29 Oct 2001 16:04:36 -0800
Message-ID: <008d01c160d6$76a7a290$426f2a40@boondocksaint> (raw)
References: <9reo1n$2521$1@news.tht.net>

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!





view thread (5+ messages)  latest in thread

Message-ID: <008d01c160d6$76a7a290$426f2a40@boondocksaint>
Permalink:  ../008d01c160d6$76a7a290$426f2a40@boondocksaint/
Also on:    postgresql.org/message-id/008d01c160d6$76a7a290$426f2a40@boondocksaint

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: jason_watkins@pobox.com
  Subject: Re: SQL99
  In-Reply-To: <008d01c160d6$76a7a290$426f2a40@boondocksaint>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox