How to flatten a database table

From: mai fawzy <maifawzy(dot)emaifaw(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to flatten a database table
Date: 2010-06-22 08:38:04
Message-ID: AANLkTimGSrZ85t2rMdRrad2MIsa6kFS27zqUQYC4EH_5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I have a table that has the following fields:

ID Money Date State
1 20 2010-01-01 done
2 10 2010-01-02 done
3
.
.
.
.
n

I need to select the values from this table to join them 2 another select
statement but the problem that I need to flatten this table first.
I need the returned values to be as one row. how can this be implemented??

Thanks a lot,
Mai

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2010-06-22 08:45:17 Re: How to flatten a database table
Previous Message Devrim GÜNDÜZ 2010-06-22 05:36:22 Re: High Availability with Postgres