Re: Ambiguous columns - Mailing list pgsql-novice

From Jeffrey Melloy
Subject Re: Ambiguous columns
Date
Msg-id 42CAFDCD.6060102@visualdistortion.org
Whole thread Raw
In response to Ambiguous columns  (Steve Tucknott <steve@retsol.co.uk>)
List pgsql-novice
Steve Tucknott wrote:

>If I have two tables(taba, tabb) with the same column (column1) name and
>try to do:
>
>SELECT taba.column1 AS column1,tabb.column2 AS column2
>    FROM taba AS a
>         JOIN tabb AS b
>         ON  taba.indexCol = tabb.indexCol
>GROUP BY column1
>
>It tells me that column1 is ambiguous. Is that to be expected? I can
>semi see why - but I thought you could only only group on selected
>fields, and the only 'selected' column1 is that from taba. Minor issue,
>with easy work around.
>
>
Oracle has a fun bug in this case when it picks which table/column to do
the group by on randomly.  Or it uses some kind of crazy psychic power
to determine which table you DON'T mean, and use that.

Jeff

pgsql-novice by date:

Previous
From: "David"
Date:
Subject: Backups - WAL archiving. problem understanding documentation
Next
From: "Mike Fahrenkrog"
Date:
Subject: Batch Scripting of DB Objects to Separate Files