Thread

Re: [HACKERS] PC Week PostgreSQL benchmark results posted online (fwd)

Jose Soares <jose@sferacarta.com> — 2000-02-18T13:47:26Z

Jan Wieck wrote:

> > Tim Dyck asked me to forward this on to the list.
> >
> > *****************************
> >
> > FYI, the story is available online at:
> >
> > http://www.zdnet.com/pcweek/stories/news/0,4153,2436153,00.html
> >
> > As I think I have mentioned, I would like to review PostgreSQL 7.0 when it
> > goes gold, so if someone could let me know when it is available, that
> > would be much appreciated.
>
>     And that'll be an interesting one. Just looked into the MSSQL
>     7.0 docs today.  They  don't  have  referential  actions!  So
>     something  like ON UPDATE CASCADE/... must be implemented the
>     hard way as triggers.  Need to look it up once again tomorrow
>     to see if constraints can be deferred or not.
>
>     On  this detail, we already left at least one (and definitely
>     not the smallest) commercial database behind on  the  way  to
>     SQL3.
>
>     Can someone take a look at Interbase, Oracle and others about
>     it?
>
> Jan
>
> --
>

Borland Interbase 4.0 syntax:

contraint_def:
{ PRIMARY KEY | UNIQUE (col [, col...] )
| FOREIGN KEY (col [, col...])  REFERENCES other_table
| CHECK (<search_condition>)
}


--
Jose' Soares
Bologna, Italy                     Jose@sferacarta.com