Bruce Momjian <bruce@xxxxxxxxxx> writes: > Yaroslav Tykhiy wrote: >> SELECT * FROM foo.bar WHERE bar.a=1; >> ^^^ this means foo.bar >> Do you think it's a feature or a bug? :-) > Feature, and SQL-standard behavior. It might be worth pointing out that this has nothing to do with search_path; rather, the key is that the FROM clause establishes a table alias "bar" for the query. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
