From: Oliveiros d'Azevedo Cristina <oliveiros.cristina@marktest.pt>
To: ced <cedric@dreamgnu.com>
To: pgsql-sql@postgresql.org
Subject: Re: Outer join construction step :strange results
Date: Mon, 28 Jun 2010 13:40:40 +0100
Message-ID: <10B2957382DB4803B59D6ECB7FBCA945@marktestcr.marktest.pt> (raw)
References: <4C28736E.8030409@dreamgnu.com>
<72B95859322043DF995F2012194B4754@marktestcr.marktest.pt>
<4C288765.8080604@dreamgnu.com>
> Oliveiros d'Azevedo Cristina wrote:
>> Howdy, Cedric .
>>
>> Before analysing this problem of yours further, I 'd like you to
>> kindly clarify me some points, please
>>
>>
>>
>>>
>>> I have table following tables T0,T1,T2,T3, T1T2
>>> with
>>> -T0(id, fk_T1)
>>> -T1(id )
>>> -T2(id, fk_T3)
>>> -T1T2(fk_T1,fk_T2)
>>> -T3 (id)
>>>
>>> The table T0 represents sets of T1 items.
>>> The table T1 represents items.
>>> The table T3 represents property types.
>>> The table T2 represents represents property values of a specific type.
>>>
>>
>>
>> T0.id is not a primary key, is it?
> all columns with id are Primary keys
> all columns with fk_T1 are foreign keys
Can you specify a little more how you represent T1 item sets with this data
model?
What exactly represents one row from table T0? A pair (id, fk_T1) ? A set
with just one element?
Best,
Oliveiros
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: oliveiros.cristina@marktest.pt, cedric@dreamgnu.com
Subject: Re: Outer join construction step :strange results
In-Reply-To: <10B2957382DB4803B59D6ECB7FBCA945@marktestcr.marktest.pt>
* 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