I'm missing outer joins - Mailing list pgsql-sql

From bill@wadley.org
Subject I'm missing outer joins
Date
Msg-id Pine.LNX.4.21.0006011447200.13448-100000@wadley.org
Whole thread Raw
List pgsql-sql
Hello!

Well, I have a need for an OUTER JOIN, but have semi-solved it by using
a UNION. However, I can't do an ORDER BY on a UNION, and have since
discovered that a VIEW can not be used with a UNION.

Is there another way (possibly with one or more FUNCTIONs), for me to get
this join on two tables (where one table may have no matching rows) via a
single sorted query?

Thanks!

Bill



pgsql-sql by date:

Previous
From: mikeo
Date:
Subject: short query becomes long
Next
From: p.lam@altavista.net
Date:
Subject: Simulating CURSORS??