On 10/19/12, Vik Reykja <vikrey...@gmail.com> wrote: > On Thu, Oct 18, 2012 at 5:40 PM, <maxim.bo...@gmail.com> wrote: > >> The following bug has been logged on the website: >> >> Bug reference: 7612 >> Logged by: Maxim Boguk >> Email address: maxim.bo...@gmail.com >> PostgreSQL version: 9.2.1 >> Operating system: Linux >> Description: >> >> Join between two values() set could produce wrong results: >> > > This is not a bug; your test case produces correct results. > > Your VALUES clauses are producing one row with two columns each called > "val" and "column2". You are joining on val and so when you switch the > values to put 2 in different columns, no results are found. > > Is it possible you didn't intend to put the parentheses immediately > following the VALUES keyword? I think that is the case because your > parentheses around the numbers are superfluous.
Oops sorry for noise. I should be more careful. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs