some questions

Поиск
Список
Период
Сортировка
От Ludwig Lim
Тема some questions
Дата
Msg-id 20020727022615.64175.qmail@web40016.mail.yahoo.com
обсуждение исходный текст
Ответы Re: some questions  (Bruno Wolff III <bruno@wolff.to>)
Список 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 по дате отправления:

Предыдущее
От: Thiemo Kellner
Дата:
Сообщение: Alter column
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: some questions