Path: utzoo!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!usc!apple!amdahl!rtech!brunjes
From: brunjes@rtech.rtech.com (roy brunjes)
Newsgroups: comp.databases
Subject: DB Procedures (Was: Client/Server processes and implementations)
Summary: INGRES also has them
Keywords: Database Procedures, SQL
Message-ID: <4167@rtech.rtech.com>
Date: 27 Nov 89 16:45:00 GMT
References: <7114@sybase.sybase.com> <6895@sybase.sybase.com> <2184@kodak.UUCP> <375@xyzzy.UUCP> <510@xyzzy.UUCP> <7185@sybase.sybase.com> <7189@sybase.sybase.com>
Reply-To: brunjes@rtech.UUCP (roy brunjes)
Organization: INGRES Corporation, Alameda CA
Lines: 21

In article <7189@sybase.sybase.com> coop@phobos.UUCP (John Cooper) writes:
...
>I believe Sybase is the only RDBMS that has stored procedures.  For those who
>aren't familiar with them in general:
> Stored procedures are batches of SQL code which can be created and stored in
> a database ...

Nope.  Not quite true.  INGRES has offered stored DB procedures for quite some
time now (since V 6.1), and in fact, with V 6.3 (recently announced) you can
add rules that are automatically invoked when the affected column of a given
table is written to (via insert, update, or delete SQL statement).  You are
not limited to the number of rules you can specify for a table.

This is just one of MANY new features in V 6.3 of INGRES -- The Intelligent
Database.

Roy Brunjes
INGRES Corp.

Disclaimer:  These opinions are entirely my own and not those of
             INGRES Corporation.


Brought to you by Super Global Mega Corp .com