X-Original-To: pgsql-sql@postgresql.org
Received: from news.hub.org (news.hub.org [64.49.215.80])
	by postgresql.org (Postfix) with ESMTP id 03F3C474E44
	for <pgsql-sql@postgresql.org>; Thu, 13 Mar 2003 08:48:52 -0500 (EST)
Received: by news.hub.org (Postfix, from userid 8)
	id CEEAD43A611; Thu, 13 Mar 2003 08:48:16 -0500 (EST)
From: "speakeasy" <nospam_artd@speakeasy.net>
X-Newsgroups: comp.databases.postgresql.sql
Subject: Re: View - Join based on dis-similar data types
Date: Thu, 13 Mar 2003 08:48:11 -0500
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <QNKdnanqAcK_Ee2jXTWcqw@speakeasy.net>
Lines: 37
X-Complaints-To: abuse@speakeasy.net
X-DMCA-Complaints-To: abuse@speakeasy.net
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint
	properly
X-Postfilter: 1.1
To: pgsql-sql@postgresql.org
X-Archive-Number: 200303/350
X-Sequence-Number: 12389

Not sure if this ever made it to the group, I can't seem to find it in the
recent message lists.

"speakeasy" <nospam_artd@speakeasy.net> wrote in message news:...
> I have a field defined as a character(50) data type, and the same field
> stored in a transition table as a text type.
>
> The view itself work based on the join, however sub-queries against the
view
> on that field do not return any data.
>
> Example:
>
> Table1
> ----
> T1Data - Character(50)
>
>
> Table2
> ----
> T2Data - Text
>
>
> View1:
> ---
> SELECT T1Data from Table1 JOIN Table2 ON (Table1.T1Data = Table2.T2Data);
>
>
> A select against View1
> SELECT * FROM View1 returns all relevant records, however, adding a WHERE
> clause produces no output.
>
> Please advise.
>
>