Re: Displaying two tables side by side

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Andreas Haumer <andreas(at)xss(dot)co(dot)at>
Subject: Re: Displaying two tables side by side
Date: 2004-08-11 20:15:51
Message-ID: 411A7E77.3080007@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Andreas Haumer wrote:

| test=# select * from t1 right outer join t2 on (t1.ctid=t2.ctid);

"full outer join" is better in this case.

Regards
Gaetano Mendola

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBGn5f7UpzwH2SGd4RAjP2AKCZVDTMWX87VXI7SfpAyWsJ57NlygCg6Ki9
5kOVpxAY5KPkHxpwpWFdEcY=
=O/Yc
-----END PGP SIGNATURE-----

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Lars Erik Thorsplass 2004-08-11 20:19:30 Fwd: Inserts with incomplete rows... NOT NULL constraints
Previous Message John DeSoi 2004-08-11 19:47:28 Re: sleep function