Hi, I have been making some test with EXISTS and I found I case that I do not understand too well:
CREATE TABLE testing ( number_id serial, number1 integer, number2 integer ); INSERT INTO testing (number1, number2) VALUES (1,1),(1,2),(2,3); SELECT * FROM testing WHERE EXISTS (SELECT 1 FROM testing WHERE testing.number_id = number_id AND number1 = 1); As far I understand the documentation the select query should return row 1 and 2, but it is returning 1, 2 and 3. Why is this happening ? PS_ PostgreSQL 9.1.1 on i686-pc-linux-gnu, compiled by gcc (Debian 4.3.2-1.1) 4.3.2, 32-bit Regards, Ruben
