On Wed, Feb 22, 2017 at 8:08 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:

> Or else not generate
> a name at all, in which case there simply wouldn't be a way to refer to
> the subquery by name; I'm not sure what that might break though.

​Yeah, usually when I want this I don't end up needing refer by name:

First I write:

SELECT * <with aliasing and stuff>
FROM <some complexity here​>

The decide I need to do some result filtering

<original query>
) --ooops, forgot the alias

Its for interactive use - and in fact I don't think I'd want to leave my
production queries without names.

David J.

Reply via email to