Skip site navigation (1) Skip section navigation (2)

Re: [SQL] JOIN

From: "Loredana Curugiu" <loredana(dot)curugiu(at)gmail(dot)com>
To: "Oliveiros Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt>, pgsql-novice(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] JOIN
Date: 2007-06-05 14:57:13
Message-ID: 1c23c8e70706050757r212f0369oaee3909598ce7097@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-sql
On 6/5/07, Oliveiros Cristina <oliveiros(dot)cristina(at)marktest(dot)pt> wrote:
>
>  Hello again, Loredana.
>
>
> Additional information required :-)
>
> imagine the following situation
>
> 1| LIA | recv1 | date1 | (date1,date2)
> 2|LIA | recv1 |date 1 | (date2,date3)
> 3| LIA | recv1 | date1 | (date1,date3)
>
>
> Should this yield 6? Or 4?
>
date 1 is not on the second dates column, but it is on the remaining two
>

if the first column is count then the sum(count) should be 4.


Loredana

In response to

pgsql-novice by date

Next:From: Oliveiros CristinaDate: 2007-06-05 15:00:27
Subject: Re: [SQL] JOIN
Previous:From: Oliveiros CristinaDate: 2007-06-05 14:52:49
Subject: Re: [SQL] JOIN

pgsql-sql by date

Next:From: Oliveiros CristinaDate: 2007-06-05 15:00:27
Subject: Re: [SQL] JOIN
Previous:From: Oliveiros CristinaDate: 2007-06-05 14:52:49
Subject: Re: [SQL] JOIN

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group