some questions - Mailing list pgsql-novice

From Ludwig Lim
Subject some questions
Date
Msg-id 20020727022615.64175.qmail@web40016.mail.yahoo.com
Whole thread Raw
Responses Re: some questions  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-novice
Hi:

1)
    When I do the ff sql statement
    select foo
    from bar
    limit n;

    Is it the same as :
    select foo
    from bar
    order by oid
    limit n;

   The the displaying of the result of a SELECT
statement without the ORDER BY clause reflects the
chronological order of insertion? If yes, Does this
this mean that if we don't need use to use SEQUENCES
if we just want to keep track the order of insertion
by chronological order?
   Can we oid to keep track of the order of insertion
by chronological order?

2)Just for clarification. In the FAQ:
4.16.3) Don't currval() and nextval() lead to a race
condition with other users?
 No. This is handled by backends.

  So this means the sequences doesn't affect speed of
insertion. Is this correct?

Thank you very much,

ludwig





__________________________________________________
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com

pgsql-novice by date:

Previous
From: Thiemo Kellner
Date:
Subject: Alter column
Next
From: Bruno Wolff III
Date:
Subject: Re: some questions