Thank you very much.
Much appreciated.
NK
- Original Message -
From: Bruno Wolff III <[EMAIL PROTECTED]>
Date: Friday, July 14, 2006 2:50 pm
Subject: Re: Dynamic table with variable number of columns
> On Wed, Jul 12, 2006 at 13:38:34 -0700,
> [EMAIL PROTECTED] wrote:
> > Hi,
> > Thanks
Hi,
Thanks again.
One more question. Will crosstab function work if i will not know the
number/names of columns before hand? Or I need to supply colum
headings?
Thanks again.
NK
Bruno Wolff III wrote:
> On Wed, Jul 12, 2006 at 07:08:15 -0700,
> [EMAIL PROTECTED] wrote:
> >
> > Thank you for t
Hi Thomas,
No I actually need the product name (prod1, prod2) to become column headings, which is effectively transposing the table.
Thanks.
NK
- Original Message -
From: Thomas Burdairon <[EMAIL PROTECTED]>
Date: Wednesday, July 12, 2006 10:53 am
Subject: Re: [GENERAL] Dynamic table
Hi Thomas,
No I actually need the product name (prod1, prod2) to become column
headings, which is effectively transposing the table.
Thanks.
NK
Thomas Burdairon wrote:
> if i understand well you need to have an history for your products.
> i would have a table B with
> date produ
Bruno Wolff III wrote:
> On Tue, Jul 11, 2006 at 06:05:18 -0700,
> [EMAIL PROTECTED] wrote:
> > Hello,
> > I'm a pgsql novice and here is what I'm trying to do:
> > 1.I need to create a dynamic table with the column names fetched
> > from the database using a select statement from some other
Hello,
I'm a pgsql novice and here is what I'm trying to do:
1.I need to create a dynamic table with the column names fetched
from the database using a select statement from some other table. Is
it possible? Could you point me to a simple example on how to do it?
2. I would like to compare
