AW: [HACKERS] SELECT ... AS ... names in WHERE/GROUP BY/HAVING - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: [HACKERS] SELECT ... AS ... names in WHERE/GROUP BY/HAVING
Date
Msg-id 219F68D65015D011A8E000006F8590C603FDC1D3@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> Yes, you are right, of course, it doesn't mean that it's incorrect.
> However, assuming that Oracle adheres strictly to the 
> standard (which is a
> good, but not infallible, assumption), 

Which imho is a bad assumption (take Oracle's outer join syntax e.g.).

> it means that we don't.  Of course,
> we may just extend the standard, but in this particular area, 
> I'm not sure that it's a good idea,

imho the advantage to have it is big.

> because it can be very confusing, and lead to
> inadvertent mistakes, which can be very difficult to find.

In what particular way ? Please give an example.
Imho it is bad practice if you call your labels like possible 
column names anyway.

Andreas


pgsql-hackers by date:

Previous
From: Ed Loehr
Date:
Subject: Re: [HACKERS] Postmaster options, process spawning, logging, etc.
Next
From: Jose Soares
Date:
Subject: Re: [HACKERS] \copy problem