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