Re: how to deteck empty tables in outer joins - Mailing list pgsql-novice

> SELECT *,NULL FROM a; How can I implement this?

Try 7.1beta.  It supports all the joins.  You'd be able to just do:

select * from a left join b using (id);

--
------------------------------------------------
-- Robert B. Easter
-- reaster@comptechnews.com
-- http://www.comptechnews.com/~reaster/
-- Linux Support: http://www.comptechserv.com/
------------------------------------------------