Yaroslav Tykhiy wrote: > Hi there, > > Sorry but I've got yet another issue to discuss today, this time that > on schema search path. In fact it may not be a bug, but it may be > worth a note in the documentation. > > It seems that if the table in SELECT FROM has an explicit schema > specifier, further references to the same table name will implicitly > inherit it. E.g., this query will be valid because the second > reference will be to foo.bar not public.bar: > > SELECT * FROM foo.bar WHERE bar.a=1; > ^^^ this means foo.bar No one has ever complained about this before. > As just shown, this can be even more confusing with nested queries. > > Do you think it's a feature or a bug? :-) Feature, and SQL-standard behavior. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
