Rod Taylor <[EMAIL PROTECTED]> writes:
> SubSelects have undergone a large simplification by Tom while
> implementing read-only plans in the executor. This seems to have
> accidentally fixed this case.
Nothing accidental about it.
http://archives.postgresql.org/pgsql-general/2002-12/msg00375.php
Markus Bertheau <[EMAIL PROTECTED]> writes:
> PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2
> datetest=# select * from (select (select count(1) from (select von from
> daten union select bis as von from daten) as d1 where d1.von < d2.von)
> as number, von from (select von f
> datetest=# select * from (select (select count(1) from (select von from
> daten union select bis as von from daten) as d1 where d1.von < d2.von)
> as number, von from (select von from daten union select bis as von from
> daten) d2) as table1 join (select (select count(1) + 1 from (select von
> f
Hi,
datetest=# select version();
version
--
PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2
(1 запись)
datetest=# \d daten