Re: Assembling "top features" list for beta announcement
Kevin Grittner <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.advocacy |
|---|---|
| Message-ID | <CACjxUsNSLLMQpCL3AcmZj8AfFd7fb=uw+Oajb+BAkfzg6OUKig@mail.gmail.com> |
On Fri, Apr 7, 2017 at 5:35 PM, Thomas Kellerer <[email protected]> wrote: > Kevin Grittner schrieb am 08.04.2017 um 00:01: >> >> I don't think it merits top 2-4 features, but transition tables for >> AFTER triggers is a SQL standard feature that I think most products >> have had and we have not ... until v10. > > I think only SQL Server and DB2 have that. SAP SQL Anywhere also supports it and Sybase ASE supports the capability, but with fixed names for the transition tables (inserted and deleted). > Oracle has no such thing for their statement level trigger (it can be > implemented using a compound trigger and a temporary table) > > MySQL has no statement level triggers SAP MaxDB and SQLite are in the same camp as MySQL in this regard -- no support for it. -- Kevin Grittner -- Sent via pgsql-advocacy mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-advocacy