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
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
WHERE
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 separate from
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 saying
that
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