pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
SQL99
5+ messages / 5 participants
[nested] [flat]

* SQL99
@ 2001-10-27 16:38 Valdir H. Dias Leite <valdirh@uol.com.br>
  2001-10-29 22:50 ` Re: SQL99 Roberto Mello <rmello@cc.usu.edu>
  2001-10-30 00:04 ` Re: SQL99 Jason Watkins <jason_watkins@pobox.com>
  0 siblings, 2 replies; 5+ messages in thread

From: Valdir H. Dias Leite @ 2001-10-27 16:38 UTC (permalink / raw)
  To: pgsql-sql

Hello!

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!





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: SQL99
  2001-10-27 16:38 SQL99 Valdir H. Dias Leite <valdirh@uol.com.br>
@ 2001-10-29 22:50 ` Roberto Mello <rmello@cc.usu.edu>
  1 sibling, 0 replies; 5+ messages in thread

From: Roberto Mello @ 2001-10-29 22:50 UTC (permalink / raw)
  To: Valdir H. Dias Leite <valdirh@uol.com.br>

On Sat, Oct 27, 2001 at 02:38:05PM -0200, Valdir H. Dias Leite wrote:
> Hello!

Tudo bem Valdir?
 
> PortgreSQL is implementing full SQL99 specification? In which relase?

No.
 
> Where can i find further info about ANSI SQL 99 and others DBMS which
> implement SQL 99?

AFAIK, there is not a single database vendor who has implemented full
SQL99. It probably won't happen in the near future.

PostgreSQL complies to a lot of the standard. 

-Roberto
-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net 
       http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
Monday is a bad way to spend 1/7 of your life.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: SQL99
  2001-10-27 16:38 SQL99 Valdir H. Dias Leite <valdirh@uol.com.br>
@ 2001-10-30 00:04 ` Jason Watkins <jason_watkins@pobox.com>
  2001-10-30 17:01   ` Re: SQL99 Jochem van Dieten <nomail@dev.null>
  1 sibling, 1 reply; 5+ messages in thread

From: Jason Watkins @ 2001-10-30 00:04 UTC (permalink / raw)
  To: 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!





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: SQL99
  2001-10-27 16:38 SQL99 Valdir H. Dias Leite <valdirh@uol.com.br>
  2001-10-30 00:04 ` Re: SQL99 Jason Watkins <jason_watkins@pobox.com>
@ 2001-10-30 17:01   ` Jochem van Dieten <nomail@dev.null>
  0 siblings, 0 replies; 5+ messages in thread

From: Jochem van Dieten @ 2001-10-30 17:01 UTC (permalink / raw)
  To: pgsql-sql

Jason Watkins wrote:

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


Where?

Jochem




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: SQL99
@ 2001-11-06 21:10 Josh Berkus <josh@agliodbs.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Josh Berkus @ 2001-11-06 21:10 UTC (permalink / raw)
  To: pgsql-sql

Folks,

> Yeah. Considering that no vendor has yet to implement full SQL-92 I
> guess 
> it will take a long time before anyone complies to full SQL-99...

Plus some folks don't think SQL99 was such a keen idea.  Kline, Kline &
Kline from O'Reilly, for example, seem to think that most of the changes
between the two versions were vendor-inspired and don't do anything to
improve database-building.  For example, the huge focus on BLOB support
in SQL 99 begs the question: Should BLOBs be stored in the database at
all?  Many DBAs would say no ...

I'm sticking with SQL92.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2001-11-06 21:10 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-10-27 16:38 SQL99 Valdir H. Dias Leite <valdirh@uol.com.br>
2001-10-29 22:50 ` Roberto Mello <rmello@cc.usu.edu>
2001-10-30 00:04 ` Jason Watkins <jason_watkins@pobox.com>
2001-10-30 17:01   ` Jochem van Dieten <nomail@dev.null>
2001-11-06 21:10 Re: SQL99 Josh Berkus <josh@agliodbs.com>

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