Re: Subselect with no records results in final empty set
От | Sterpu Victor |
---|---|
Тема | Re: Subselect with no records results in final empty set |
Дата | |
Msg-id | emacbd7e44-dc07-4984-b4e8-1f59f7958d6c@victor-pc обсуждение исходный текст |
Ответ на | Re: Subselect with no records results in final empty set (David G Johnston <david.g.johnston@gmail.com>) |
Ответы |
Re: Subselect with no records results in final empty set
Re: Subselect with no records results in final empty set |
Список | pgsql-general |
It works as you sugested, this is the syntax I used: SELECT * FROM (SELECT 1 AS t1, 2 AS t2) AS t1 LEFT JOIN (SELECT * FROM atc WHERE id = '1231222') AS t2 ON (null) Thank you. ------ Original Message ------ From: "David G Johnston" <david.g.johnston@gmail.com> To: pgsql-general@postgresql.org Sent: 1/29/2015 10:03:38 PM Subject: Re: [GENERAL] Subselect with no records results in final empty set >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@postgresql.org) >To make changes to your subscription: >http://www.postgresql.org/mailpref/pgsql-general --- This email has been checked for viruses by Avast antivirus software. http://www.avast.com
В списке pgsql-general по дате отправления: