how to deteck empty tables in outer joins
| От | Einar Karttunen |
|---|---|
| Тема | how to deteck empty tables in outer joins |
| Дата | |
| Msg-id | Pine.LNX.4.30.0102011347430.24468-100000@melkinpaasi.cs.Helsinki.FI обсуждение исходный текст |
| Ответ на | list of data types ("Derek" <derek.mailer@virgin.net>) |
| Ответы |
Re: how to deteck empty tables in outer joins
Re: how to deteck empty tables in outer joins |
| Список | pgsql-novice |
Im trying to do an outerjoin of two tables. The second one might be empty. Normally I would use a query like: CREATE TABLE a ( id INTEGER ); CREATE TABLE b ( id INTEGER ); SELECT * FROM a,b WHERE a.id=b.id UNION ALL SELECT * FROM a,b WHERE a.id NOT IN (b.id) ; If the seconf table is empty the result is null, because the cartesian product of table and null is null. What I want is to include a condition that if b has no rows then just add null for the value of b ie. SELECT *,NULL FROM a; How can I implement this? - Einar Karttunen
В списке pgsql-novice по дате отправления: