Visibility of table aliases in CTEs - Mailing list pgsql-general

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
rod@iol.ie