Oliver Jowett wrote:

>> Which one of these behaviors is the right one ? Thanks in advance !
>
> Both are equally correct, I believe. I think the JDBC spec is silent
> about which column you get back if there is ambiguity.

Actually it says something about this.
"If a select list contains the same column more than once, the first
instance of the column will be returned" (JDBC3 §14.2.3 and JDBC4 §15.2.3)

--Magne

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq