Subject: Re: merge-join for domain with underlying type text
From: Rod Taylor <rbt@rbt.ca>
To: Randall Lucas <rlucas@tercent.net>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <0ED09669-832B-11D7-B164-000A957653D6@tercent.net>
References: <0ED09669-832B-11D7-B164-000A957653D6@tercent.net>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-pbTXOIqpoyqwxboKKooE"
Organization: 
Message-Id: <1052604804.48831.19.camel@jester>
Mime-Version: 1.0
Date: 10 May 2003 18:13:25 -0400

--=-pbTXOIqpoyqwxboKKooE
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Sat, 2003-05-10 at 17:04, Randall Lucas wrote:
> Hi Folks,
>=20
> If I have a domain defined with an underlying type of "text" or=20
> "varchar," and I need to FULL OUTER JOIN two tables based upon the=20
> similarity in these fields, I am getting:

Seems it works perfectly fine with integers and text based domains on
7.3 and 7.4.  Do you have a full failing example?

junk=3D# create domain int as integer;
CREATE DOMAIN
junk=3D# create table a (col1 int);
CREATE TABLE
junk=3D# create table b (col1 int);
CREATE TABLE
junk=3D# select * from a full outer join b using (col1);
 col1
------
(0 rows)
=20
junk=3D# select version();
                                version
------------------------------------------------------------------------
 PostgreSQL 7.4devel on i386-unknown-freebsd4.8, compiled by GCC 2.95.4
(1 row)

--=20
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

--=-pbTXOIqpoyqwxboKKooE
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (FreeBSD)

iD8DBQA+vXmE6DETLow6vwwRAohNAJ45hIAI2N10hfqfW6PUUSAaANKZmgCZAVlp
HYmigPn/XVlGyCm9BBiv5Xs=
=PNDt
-----END PGP SIGNATURE-----

--=-pbTXOIqpoyqwxboKKooE--