From: Randall Lucas <rlucas@tercent.net>
To: pgsql-sql@postgresql.org
Subject: merge-join for domain with underlying type text
Date: Sat, 10 May 2003 17:04:58 -0400
Message-ID: <0ED09669-832B-11D7-B164-000A957653D6@tercent.net> (raw)
In-Reply-To: <F9B58582-830D-11D7-B164-000A957653D6@tercent.net>
Hi Folks,
If I have a domain defined with an underlying type of "text" or
"varchar," and I need to FULL OUTER JOIN two tables based upon the
similarity in these fields, I am getting:
ERROR: FULL JOIN is only supported with mergejoinable join conditions
I have looked at the docs and it seems that it's a matter of making the
comparison operators for the domain type (as per SQL Reference ::
"CREATE OPERATOR" section). However, is there anything tricky about
adding the merge-join capability to a domain? Is there a preferred
method? Am I barking entirely up the wrong tree (could I, for example,
use a casting trick? Simply recasting the fields as type "text"
doesn't avoid the error)?
Postgres version is 7.3.
Best,
Randall
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: rlucas@tercent.net
Subject: Re: merge-join for domain with underlying type text
In-Reply-To: <0ED09669-832B-11D7-B164-000A957653D6@tercent.net>
References: <F9B58582-830D-11D7-B164-000A957653D6@tercent.net> <0ED09669-832B-11D7-B164-000A957653D6@tercent.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox