Skip site navigation (1) Skip section navigation (2)

Re: PreparedStatement vs. Statement problem

From: tivvpgsqljdbc(at)gtech-ua(dot)com
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: yoursoft <yoursoft(at)freemail(dot)hu>, Postgres JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: PreparedStatement vs. Statement problem
Date: 2007-11-29 10:18:48
Message-ID: 474E9208.8040605@gtech-ua.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Oliver Jowett wrote:
> yoursoft wrote:
>> Ok, the planner uses different way. I think the planner use the UNION
>> in PreparedStatement and not the UNION ALL?
>> How to rewrite the SQL to use the UNION ALL in preparedstatement?
>
> You need an ORDER BY or the order is undefined and unpredictable. See
> http://www.postgresql.org/docs/8.2/static/queries-order.html
>
> There's no simple way to say "give me rows from this table first"
> other than running a query on each table separately.

Actually the simple way is
select c1,c2,c3,...,cn from (select 1, table1.* from table1 union all
select 2, table2.* from table2 union all ...) a(ordercolumn, c1, c2, c3,
.., cn) order by 1





In response to

pgsql-jdbc by date

Next:From: Christian RengstlDate: 2007-11-30 10:52:39
Subject: Serial data type
Previous:From: Donald FraserDate: 2007-11-29 10:00:11
Subject: Re: ssl connection and webstart

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group