Etienne Dube etd...@gmail.com writes:
This query yields unexpected results (tested under 9.2.4):
SELECT
s.car_id,
s.color_id AS subquery_color_id,
co.color_id AS join_color_id,
co.color_name
FROM
(
SELECT
ca.car_id,
(
Hello,
Consider the following tables and data:
CREATE TABLE color (
color_id integer PRIMARY KEY,
color_name text
);
INSERT INTO color (color_id, color_name)
VALUES
(1, 'red'),
(2, 'blue'),
(3, 'green'),
(4, 'yellow'),
(5,
On 08/15/2013 11:46 AM, Etienne Dube wrote:
Hello,
I don't really understand what is going on there, the result appears
incorrect to me. The following page seems to offer some explanations as
to what is happening:
http://sql-info.de/postgresql/postgres-gotchas.html#1_6 . Indeed, adding
