I'm missing outer joins

From: bill(at)wadley(dot)org
To: pgsql-sql(at)postgresql(dot)org
Subject: I'm missing outer joins
Date: 2000-06-01 19:53:29
Message-ID: Pine.LNX.4.21.0006011447200.13448-100000@wadley.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message p.lam 2000-06-01 23:59:35 Simulating CURSORS??
Previous Message mikeo 2000-06-01 18:24:39 short query becomes long