From: ced <cedric@dreamgnu.com>
To: pgsql-sql@postgresql.org
Subject: Re: Outer join construction step :strange results
Date: Mon, 28 Jun 2010 15:46:56 +0200
Message-ID: <4C28A7D0.4060508@dreamgnu.com> (raw)
In-Reply-To: <10B2957382DB4803B59D6ECB7FBCA945@marktestcr.marktest.pt>
References: <4C28736E.8030409@dreamgnu.com>
<72B95859322043DF995F2012194B4754@marktestcr.marktest.pt>
<4C288765.8080604@dreamgnu.com>
<10B2957382DB4803B59D6ECB7FBCA945@marktestcr.marktest.pt>
Oliveiros d'Azevedo Cristina wrote:
>
>
>> 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?
(T0.id,T0.fk_T1)=(1,234),(1,235),(1,236)
234,235,236 all T1 items and 1 the set of them
> What exactly represents one row from table T0? A pair (id, fk_T1) ? A
> set with just one element?
one item in the set.
>
> 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: cedric@dreamgnu.com
Subject: Re: Outer join construction step :strange results
In-Reply-To: <4C28A7D0.4060508@dreamgnu.com>
* 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