I wrote:
> The comments for refnameRangeTblEntry indicate that at one time we
> thought we saw support for our approach in the spec:
Here is the discussion thread that settled on our current behavior:
http://archives.postgresql.org/pgsql-hackers/2002-03/msg00403.php
It looks like we followed Oracle.
regards, tom lane