Re: Schema search path

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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +