From: | Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com> |
---|---|
To: | PostgreSQL Mailing List <pgsql-novice(at)postgresql(dot)org> |
Subject: | some questions |
Date: | 2002-07-27 02:26:15 |
Message-ID: | 20020727022615.64175.qmail@web40016.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2002-07-27 11:09:33 | Re: some questions |
Previous Message | Thiemo Kellner | 2002-07-27 01:46:30 | Alter column |