pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Loredana Curugiu <loredana.curugiu@gmail.com>
To: Oliveiros Cristina <oliveiros.cristina@marktest.pt>
To: pgsql-novice@postgresql.org
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] JOIN
Date: Tue, 5 Jun 2007 17:57:13 +0300
Message-ID: <1c23c8e70706050757r212f0369oaee3909598ce7097@mail.gmail.com> (raw)
In-Reply-To: <010001c7a781$300481d0$ec5a3d0a@marktestcr.marktest.pt>
References: <1c23c8e70706050111i5ba672d6j78bd9afa4b786616@mail.gmail.com>
	<1c23c8e70706050426y12d567ban70ffdafb75808e0e@mail.gmail.com>
	<f54607780706050619u2e2c12dpcc3a4414370e0636@mail.gmail.com>
	<1c23c8e70706050708h6c5b708dpc2f53ff76a73740c@mail.gmail.com>
	<1c23c8e70706050715y45688e12n90fcf8cecd84b251@mail.gmail.com>
	<010001c7a781$300481d0$ec5a3d0a@marktestcr.marktest.pt>

On 6/5/07, Oliveiros Cristina <oliveiros.cristina@marktest.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

view thread (22+ messages)  latest in thread

Message-ID: <1c23c8e70706050757r212f0369oaee3909598ce7097@mail.gmail.com>
Permalink:  ../1c23c8e70706050757r212f0369oaee3909598ce7097@mail.gmail.com/
Also on:    postgresql.org/message-id/1c23c8e70706050757r212f0369oaee3909598ce7097@mail.gmail.com

copy link · copy postgr.es

reply

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: loredana.curugiu@gmail.com, oliveiros.cristina@marktest.pt, pgsql-novice@postgresql.org
  Subject: Re: [SQL] JOIN
  In-Reply-To: <1c23c8e70706050757r212f0369oaee3909598ce7097@mail.gmail.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