Hello all,

In a WITH query, are table aliases within a CTE isolated from the rest
of the query? For example, if I do this -

  with my_cte as (
    select * from my_table t
  )
  ....

- can I re-use the alias "t" elsewhere in the same query?

I had a dig through the appropriate section of the docs, but the answer
wasn't obvious to me there.

Thanks,

Ray.


-- 
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to