Why do the two queries below return different results?
От | Warren Little |
---|---|
Тема | Why do the two queries below return different results? |
Дата | |
Msg-id | 1058388773.5345.8.camel@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: Why do the two queries below return different results?
|
Список | pgsql-sql |
Look at the following two queries. select casepid, origpid from virbcase where date_trunc('day', origdt) >= '2003-07-01' and date_trunc('day', origdt) <= '2003-07-31' and origpid in (select pid from party where partyid in ('00339', '00310', '00320')) and not exists (select pid from casecombo where casepid = secondpid) select casepid, origpid from virbcase where date_trunc('day', origdt) >= '2003-07-01' and date_trunc('day', origdt) <= '2003-07-31' and origpid in (select pid from party where partyid in ('00339', '00310', '00320')) and casepid not in (select secondpid from casecombo) The second query is broken and I don't understand why. Correlating the subquery as is done in the first query fixes it. -- Warren Little Senior Vice President Secondary Marketing Security Lending Wholesale, LC www.securitylending.com Tel: 866-369-7763 Fax: 866-849-8082
В списке pgsql-sql по дате отправления: