Re: Dynamically created tables [WAS Re: "Relation x

I would bet this requirement is really that the SQL SELECT column order must
match the column order of the report, which is something else entirely. If
the number of 'months' columns (per your example) are fixed, and the
specific months are known ahead of time, you could (theoretically) do
self-join. This may have to be an outer join if it is possible that there
were no entries for any particular month.

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"

> From: Gaurav Priyolkar <pgaurav(at)goatelecom(dot)com>
> Date: Tue, 16 Oct 2001 23:32:49 +0530
> To: pgsql-general(at)postgresql(dot)org
> Subject: Dynamically created tables [WAS Re: [GENERAL] "Relation x does not
> exist" ...
>
> Apparently, when creating a Delphi report, it has to be fed with data
> from a database table with exactly the columns as they are to appear
> on the report. I am just meeting the specified requirement.