X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 9D97952883
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 20 Jul 2005 13:43:23 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 16427-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 20 Jul 2005 16:43:21 +0000 (GMT)
Received: from mail.travelamericas.com (unknown [206.130.134.147])
	by svr1.postgresql.org (Postfix) with SMTP id 98FDF52914
	for <pgsql-sql@postgresql.org>; Wed, 20 Jul 2005 13:43:18 -0300 (ADT)
Received: (qmail 1954 invoked from network); 20 Jul 2005 16:43:17 -0000
Received: from unknown (HELO ?10.0.0.253?) (10.0.0.253)
	by verkiel.travelamericas.com with SMTP; 20 Jul 2005 16:43:17 -0000
Message-ID: <42DE7F24.1070506@metatrontech.com>
Date: Wed, 20 Jul 2005 09:43:16 -0700
From: Chris Travers <chris@metatrontech.com>
User-Agent: Mozilla Thunderbird 1.0 (X11/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Chris Travers <chris@travelamericas.com>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: solved: Coalesce() in outer join between views
References: <42DD6626.8010705@travelamericas.com>
In-Reply-To: <42DD6626.8010705@travelamericas.com>
Content-Type: multipart/mixed; boundary="------------060802010500010208090000"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.069 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200507/209
X-Sequence-Number: 22187

This is a multi-part message in MIME format.
--------------060802010500010208090000
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi all;
I found the problem (stupid human error ;-) )   Basically it was  a 
broken join condition.

Best Wishes,
Chris Travers
Metatron Technology Consulting

--------------060802010500010208090000
Content-Type: text/x-vcard; charset=utf-8;
 name="chris.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="chris.vcf"

begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:chris@metatrontech.com
x-mozilla-html:FALSE
version:2.1
end:vcard


--------------060802010500010208090000--