Re: trouble with query

>
>
> 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.
>
>                         regards, tom lane

Sorry, I almost forget, I think this shell may work, u have to change
path
createdb tpch
createlang 'plpgsql' tpch
psql -c '\i tables'
\i '/path/region.sql'
\i '/path/nation.sql'
\i '/path/part.sql'
\i '/path/supplier.sql'
\i '/path/customer.sql'
\i '/path/partsupp.sql'
\i '/path/orders.sql'
\i '/path/lineitem.sql'
copy region from'/path/region.dat' with NULL as 'NULL';
copy nation from'/path/nation.dat' with NULL as 'NULL';
copy part from'/path/part.dat' with NULL as 'NULL';
copy supplier from'/path/supplier.dat' with NULL as 'NULL';
copy customer from'/path/customer.dat' with NULL as 'NULL';
copy partsupp from'/path/partsupp.dat' with NULL as 'NULL';
copy orders from'/path/orders.dat' with NULL as 'NULL';
copy lineitem from'/path/lineitem.dat' with NULL as 'NULL';