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@xxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
