Kevin Grittner <kgrittn@ymail.com> wrote:
> Marti Raudsepp <marti@juffo.org> wrote:
>> What are the interactions with search_path?
>
> Pretty much the same as the interactions of RTEs with search_path.
> If the apparent relation name is not schema-qualified, parse
> analysis first tries to resolve the name as an RTE, and if that
> fails it tries to resolve it as a named tuplestore, and if that
> fails it goes to the catalogs using search_path.
Argh. s/RTE/CTE/
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company