Guys,
SQL spec aside, thinking about this from a strictly implementation/user point
of view:
(an keeping in mind that I think it's very important that we work out the
spec-correct behaviour for 7.4 and/or 7.3.3)
The particular case that Dan has raised is an issue for four reasons:
1) It looks t
On Sat, 22 Feb 2003, Tom Lane wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
> > On Fri, 21 Feb 2003, Tom Lane wrote:
> >> Anyone care to offer a gloss on the spec to prove that this behavior
> >> is correct or not correct?
>
> > Hmm, I'd read SQL92 Section 7.5 (joined tables) Syntax Rules as
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Fri, 21 Feb 2003, Tom Lane wrote:
>> Anyone care to offer a gloss on the spec to prove that this behavior
>> is correct or not correct?
> Hmm, I'd read SQL92 Section 7.5 (joined tables) Syntax Rules as saying
> that the non natural/using case is separ
On Fri, 21 Feb 2003, Tom Lane wrote:
> Dan Langille <[EMAIL PROTECTED]> writes:
> > This is the query in question:
>
> > SELECT element_id as wle_element_id, COUNT(watch_list_id)
> > FROM watch_list JOIN watch_list_element
> >ON watch_list.id = watch_list_element.watch_list_id
> > WHE
Dan Langille <[EMAIL PROTECTED]> writes:
> This is the query in question:
> SELECT element_id as wle_element_id, COUNT(watch_list_id)
> FROM watch_list JOIN watch_list_element
>ON watch_list.id = watch_list_element.watch_list_id
> WHERE watch_list.user_id = 1
> GROUP BY watch_list_el
I notice this today when migrating an application from 7.2 to 7.3. The
column name is not being recognized.
See also: http://archives.postgresql.org/pgsql-sql/2003-02/msg00480.php
This is the query in question:
SELECT element_id as wle_element_id, COUNT(watch_list_id)
FROM watch_list JOIN wat
