From: jim.bagley@traderonline.com <jim.bagley@traderonline.com>
To: Bronx <tobronx@go2.pl>
Cc: pgsql-admin@postgresql.org
Subject: Re: Is it possible in PostgreSQL?
Date: Fri, 16 Jan 2004 13:10:11 -0500
Message-ID: <40082903.2060909@traderonline.com> (raw)
In-Reply-To: <00ca01c3d968$07c05fe0$0201a8c0@bronx>
References: <00ca01c3d968$07c05fe0$0201a8c0@bronx>
In Oracle you can use cursors as columns. not sure if that will work in
postgresql. never tried it. =)
ex:
select name, curosr(select sum(quantity) from tablename where date
between(pick a date) and (pick another date)) as 01,
curosr(select sum(quantity) from tablename where date between(pick a
date) and (pick another date)) as 02,
curosr(select sum(quantity) from tablename where date between(pick a
date) and (pick another date)) as 03,
from tablename;
thanks should give you the output you described below. Again, I am not
sure if this is SQL Standard or just a function that Oracle offers.
jim
Bronx wrote:
> Hi,
> I've got problem with one specific query. I've got the table
> with many of rekords like these:
>
> name | quantity | date
> -------------------------------------------------------
> aaa 2 2003-04-01
> bbb 4 2003-04-12
> ccc 5 2003-05-12
> aaa 3 2003-01-14
> aaa 1 2003-12-09
> bbb 9 2003-08-08
>
> and so on ...
>
> Does anybody know how make query which return grouped
> records by month of year and name (also sum of quantity).
> It is possible to make a query whitch return something like that:
>
> name | 01 | 02 | 03 | 04 | ... | 12 (months)
> ------------------------------------------------
> aaa x x x x ... x
> bbb x x x x ... x
> ccc x x x x ... x
>
> where x means sum of quantity in month.
> It is possible to make it in one query?
> I know that in Access is construction : PIVOT.
>
> Thanks
> Adam
>
--
Jim Bagley
Database Manager
Trader Electronic Media
(757) 321-8409 (work)
(757) 343-1768 (cell)
www.Employmentguide.com <http://www.employmentguide.com; - Bringing
Employers and Jobseekers Together.
www.ForRent.com <http://www.forrent.com; - Nation's Leading Apartment
Rental Source.
www.HarmonHomes.com <http://www.harmonhomes.com; - Your Home Site on the
Web.
www.ParenthoodWeb.com <http://www.parenthoodweb.com; - Pregnancy and
Parenting Advice, Baby Names and More.
www.Roomsaver.com <http://www.roomsaver.com; - 6000+ Lodging Coupons.
www.TraderOnline.com <http://www.traderonline.com; - Boats, RVs,
Collector Cars, Motorcycles and More.
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: jim.bagley@traderonline.com, tobronx@go2.pl, pgsql-admin@postgresql.org
Subject: Re: Is it possible in PostgreSQL?
In-Reply-To: <40082903.2060909@traderonline.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