Re: [HACKERS] select from sequences

2007-02-12 Thread Merlin Moncure
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

[HACKERS] select from sequences

2007-02-11 Thread Jaime Casanova
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

Re: [HACKERS] select from sequences

2007-02-11 Thread Tom Lane
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)---

Re: [HACKERS] select from sequences

2007-02-11 Thread Jaime Casanova
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? --

Re: [HACKERS] select from sequences

2007-02-11 Thread Tom Lane
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