On Tue, Feb 04, 2003 at 14:11:20 -0500,
Gregory Stark <gsstark(at)mit(dot)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.