Re: Constraints and SQL3 standard

In article <1993Nov8.221806.15823_at_porthos.cc.bellcore.com> derek_at_candyland.gamekeeper.bellcore.com (C. Derek Fields) writes:
>First - is there a sql standards newsgroup. I think I get the full list of
>groups and can't imagine why there wouldn't be. How about a mailing list
>for people interested in the current (and sorry) state of the standard?

There is no SQL standards group that I know of. However you can get copies of draft standards from the /pub/standards/sql directory on gatekeeper.dec.com.

>
>Second and my real question: Does the latest proposed standard (SQL3?)
>provide for constraints and stored procedures?

Referential integrity constraints have been available since SQL-89. SQL-92 expands on them to allow cascading deletes, updates, etc. Are these the sort of constraints you are talking about?

Stored procedures are covered by Addendum 2 to the SQL-92 standard, which calls them "Persistent SQL Modules". You can find a copy of this at the above-named ftp site.

-- 
 Stephen Szalla          sms_at_mel.cocam.oz.au   
 Co-Cam Computer Group,  Tel: +61 3 286 3456    
 Melbourne, Australia    Fax: +61 3 417 7857