Re: not exactly a bug report, but surprising behaviour - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: not exactly a bug report, but surprising behaviour
Date
Msg-id 20030204195439.GA6016@wolff.to
Whole thread Raw
In response to not exactly a bug report, but surprising behaviour  (Gregory Stark <gsstark@mit.edu>)
List pgsql-general
On Tue, Feb 04, 2003 at 14:11:20 -0500,
  Gregory Stark <gsstark@mit.edu> wrote:
>
> It seems the sort operation is done very late in the process, after functions
> in the select column list have already been called and the results stored.
> This makes using sequences to generate a sequential list of numbers have a
> surprising behaviour.

You can't count on that behavior anyway. Sequences only guarenty a unique
number. Other transactions can grab values from the sequence while
your transaction is running.

pgsql-general by date:

Previous
From: RobertD.Stewart@mail.state.ky.us
Date:
Subject: Re: now() more precise than the transaction
Next
From: Stephan Szabo
Date:
Subject: Re: Drop constraint in PostgreSQL 7.1.2