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
Hi,
just for curiosity, why the code doesn't throw an error when using
sequences in the from_list of a select?
allow selects from sequences confuses many people about the correct
way of using sequences
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving
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.
regards, tom lane
---(end of broadcast)---
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?
--
Jaime Casanova [EMAIL PROTECTED] writes:
and why is this a feature? i mean, what real use it has?
To find out the parameters of an existing sequence. Remove it and
you'll break pg_dump, to say nothing of any other application.
regards, tom lane