From: mila boldareva <me@pierro.dds.nl>
To: pgsql-sql@postgresql.org
Subject: Re: LEFT JOIN and missing values
Date: Wed, 12 Mar 2003 21:49:59 +0100
Message-ID: <167817250594.20030312214959@pierro.dds.nl> (raw)
In-Reply-To: <105817169066.20030312214838@pierro.dds.nl>
References: <158808514272.20030312192423@pierro.dds.nl>
<3E6F80AB.8040709@klaster.net>
<147814986879.20030312211215@pierro.dds.nl>
<3E6F9B31.7050403@klaster.net>
<105817169066.20030312214838@pierro.dds.nl>
Tomasz,
> I think if you really need to remove your 0.5 values, you need another
> table with all possible values of id1. This table will look like:
> create table t3
> (
> id1 integer;
> );
T1 contains values of id's,
The T2 matrix is a matrix of some sort of "distances" between id's
from T1, so original T2 is a T1 x T1.
(that's what you are proposing right?)
So there is no id1, id2 in T2 that don't exists in T1,
I checked my test tables and this is indeed the case.
In other words T1 is dense, I make a left join on it and I get wrong results!
And even wrong number of tuples :-(
cheers,
Mila
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: me@pierro.dds.nl
Subject: Re: LEFT JOIN and missing values
In-Reply-To: <167817250594.20030312214959@pierro.dds.nl>
* 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