| From: | Luis Amigo <lamigo(at)atc(dot)unican(dot)es> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: trouble with query |
| Date: | 2001-12-11 18:38:49 |
| Message-ID: | 3C1652B8.B695F068@atc.unican.es |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Tom Lane wrote:
> Possibly a bug, but the query alone is useless. Can't investigate
> without a complete example (table declarations and sample data,
> not just query; preferably in the form of a psql script). Please
> see the bug reporting guidelines in the User's Guide.
>
I send u table declarations and a small part of data must be copied with
NULL as 'NULL'
it is like TPC-H
u need to create pl/pgsql
The query objetive is to determine the market share of a given nation
within a given region has changed over two years for a given part type.
Thanks in advance and regards Tom
| Attachment | Content-Type | Size |
|---|---|---|
| customer.sql | text/plain | 288 bytes |
| lineitem.sql | text/plain | 2.2 KB |
| nation.sql | text/plain | 210 bytes |
| orders.sql | text/plain | 318 bytes |
| part.sql | text/plain | 591 bytes |
| partsupp.sql | text/plain | 321 bytes |
| region.sql | text/plain | 102 bytes |
| supplier.sql | text/plain | 266 bytes |
| customer2.dat | text/plain | 8.7 KB |
| lineitem2.dat | text/plain | 254.9 KB |
| nation2.dat | text/plain | 2.2 KB |
| orders2.dat | text/plain | 137.8 KB |
| part2.dat | text/plain | 8.9 KB |
| partsupp2.dat | text/plain | 31.7 KB |
| region2.dat | text/plain | 454 bytes |
| supplier2.dat | text/plain | 616 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | infotechsys.wayne@verizon.net | 2001-12-11 18:39:21 | problem untarring the latest release |
| Previous Message | Tom Lane | 2001-12-11 18:20:17 | Re: trouble with query |