On 2/11/07, Jaime Casanova <[EMAIL PROTECTED]> wrote:
On 2/11/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Jaime Casanova" <[EMAIL PROTECTED]> writes:
> > just for curiosity, why the code doesn't throw an error when using
> > sequences in the from_list of a select?
>
> That's a feature, not a bug.
>
and why is this a feature? i mean, what real use it has?
I use it all the time. You can query the sequence for its last value
without using it first. This is a lot more useful than it appears on
the surface.
merlin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
