From: | "Sugrue, Sean" <Sean(dot)Sugrue(at)analog(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Need help building SQL query |
Date: | 2005-12-05 17:26:06 |
Message-ID: | 8FDC0F9BE1F91D44BE964AA54AAA67B6189B4C8D@wilmexm3.ad.analog.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Who can I ask about large scale use of postgresql installations in a
large company? What are the gotchas? Why
would you pay for Oracle if can use postgresql especially if it's just
for data warehousing and not a transactional.
Sean
-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Bruno Wolff III
Sent: Monday, December 05, 2005 11:46 AM
To: Robert Blixt
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Need help building SQL query
On Mon, Dec 05, 2005 at 10:28:04 +0100,
Robert Blixt <robert(dot)blixt(at)transpa(dot)se> wrote:
>
> Timereportbreak consists of four breaks for each timereport. They are
> ordered by the indexnumber (0-3). They are connected to the timereport
> table using the column timereportid.
>
> What I would like to retrieve is all columns from timereport and the
> four timereportbreaks connected to the timereport table.
> However, since each break is not a separate column I am not sure how
> to solve this. And since this database already has data in it. I can't
> remodel the table. This is the output I want:
Normally you want to do this by joining to Timereportbreak once for each
break (i.e. 4 times) using a different table alias for each join. Then
you can use the a different condition on indexnumber for each alias to
get the appropiate break.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
From | Date | Subject | |
---|---|---|---|
Next Message | Ângelo Marcos Rigo | 2005-12-05 18:33:13 | Date Format Question |
Previous Message | Bruno Wolff III | 2005-12-05 16:46:11 | Re: Need help building SQL query |