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
On Wed, Jul 12, 2006 at 13:38:34 -0700,
[EMAIL PROTECTED] wrote:
> 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?
I checked a bit into this, and the actual contrib name is
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
table with variable number of columns
> if i understand well you need to have an history for your products. > i would have a table B with > date products price > 1/1/2006 prod1 1.0 > 1/1/2006 prod2 3.0 > > or repl
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
On Wed, Jul 12, 2006 at 07:08:15 -0700,
[EMAIL PROTECTED] wrote:
>
> Thank you for the suggestions.
> I will try to describe the problem better.
> I have two problems to solve. First one is that I have to transpose a
> table.
> I have table A that looks like this:
> date product price
if i understand well you need to have an history for your products.i would have a table B withdate products price1/1/2006 prod1 1.01/1/2006 prod2 3.0or replace prod_name py product_id, ... Thomas On Jul 12, 2006, at 16:08, [EMAIL PROTEC
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
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 table. Is
> it possible? Could yo
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
10 matches
Mail list logo
