Re: Subselect with no records results in final empty set
От | Sterpu Victor |
---|---|
Тема | Re: Subselect with no records results in final empty set |
Дата | |
Msg-id | em4ee6f5f5-70d5-4c7a-9e7b-118da98bb586@victor-pc обсуждение исходный текст |
Ответ на | Re: Subselect with no records results in final empty set ("Sterpu Victor" <victor@caido.ro>) |
Ответы |
Re: Subselect with no records results in final empty set
|
Список | pgsql-general |
I changed the final query to SELECT * FROM (SELECT 1 AS t1, 2 AS t2) AS t1 LEFT JOIN (SELECT * FROM atc WHERE id = '1231222') AS t2 ON (1=1) ON(null) never matched. ------ Original Message ------ From: "Sterpu Victor" <victor@caido.ro> To: "David G Johnston" <david.g.johnston@gmail.com>; pgsql-general@postgresql.org Sent: 1/29/2015 10:22:28 PM Subject: Re: [GENERAL] Subselect with no records results in final empty set >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 > > > >-- 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 по дате отправления: