Sterpu Victor wrote > Hello > > I have this select where the last subselect will return a empty set and > because of this the whole select will be empty. > How can I change this syntax so I will have a row result even if the > last select is empty? > > SELECT * FROM (SELECT 1 AS t1, 2 AS t2) as t, (SELECT 3 AS t3) as s, > (SELECT * FROM atc WHERE id = '1231222' LIMIT 1 OFFSET 0) AS s3; Use explicit join syntax; and then pick the "LEFT [OUTER] JOIN" variant. SELECT FROM t LEFT JOIN s3 ON (TRUE) David J. -- View this message in context: http://postgresql.nabble.com/Subselect-with-no-records-results-in-final-empty-set-tp5836011p5836014.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
