| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian Rengstl | 2007-11-30 10:52:39 | Serial data type |
| Previous Message | Donald Fraser | 2007-11-29 10:00:11 | Re: ssl connection and webstart |