Re: World's No.1 SQL server!! PostgreSQL defeated Oracle, MS SQLserver, DB2, Sybase, Interbase....!!!!

Oracle uses "sequences" for auto-numbering. You define a sequence just like you define a trigger or function. Then you can select the next number from the sequence whenever you need it, and Oracle keeps track. You can, of course, write an insert trigger that automatically selects and inserts the next sequence for all new rows.

Troy Wolf
troy_at_troywolf-nospam-.com

"Jonathan Willcock" <Jonathan_at_FESoftware.com> wrote in message news:8upftq$1o78$1_at_euler.space.net...
> I think you should be fair here. The pages quoted specifically say that
> they are not allowed to reveal the names of Proprietary 1 and 2 due
> to vendor restrictions, not because they don't want to. They do however
> say Prop 1 version no was 8.1.5 and Prop 2 Version 7.0. Moreover
> Prop 2 only runs on NT.
>
> No prizes for spotting that Prop 2 is MS SQL Server, and 8.1.5 sounds
> very like Oracle.
>
> Of course they could be being "economical with the truth" and I have yet
 to
> see any database vendor unable to come up with a benchmark that shows
> it top! I always advise people to devise their own tests simulating as
 near
> as possible their own needs. I for one was recently very impressed with
> MySQL - if you don't need transactions etc. and aren't too concerned with
> safety, it's certainly quick! But how many customers are not worried
 about
> data integrity and uptimes?
>
> In fact I'm currently trying to test Oracle myself for a German client,
 and
> have
> hit a brick wall. Does Oracle have an AutoIncrement field (i.e an
> automatically increasing counter)? My German is normally OK but all my
 docs
> are in German and I can't guess what the German should be for this! Can
> anyone help please???
>
> Thanks,
>
> Jonathan
>
>
> "David Fitzjarrell" <oratune_at_aol.com> wrote in message
> news:8uh7ds$5r1$1_at_nnrp1.deja.com...
> >
> >
> > Funny, the 'benchmarks' don't mention Oracle at all, just 'Proprietary
> > 1' and 'Proprietary 2'; apparently they didn't run tests against Oracle
> > but they're trying to extrapolate the results to include all major
> > RDBMS vendors. I'll bet this same crap is in the Sybase and Informix
> > newsgroups as well.
> >
> > Generate some results that prove PostgreSQL is better than Oracle.
> > Then come back and blow your horn, if you can.
> >
> > --
> > David Fitzjarrell
> > Oracle Certified DBA
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Thu Nov 16 2000 - 15:56:20 CST