Re: [SQL] strange query execution times

2001-10-04 Thread Markus Bertheau
On Tue, 2001-10-02 at 17:49, Tom Lane wrote: > Markus Bertheau <[EMAIL PROTECTED]> writes: > > r_kunden_anbieter describes the relationship between customers and > > suppliers. there are five status, 0 to 4 in attribute beziehung. both > > queries return the same results. they select all customers

Re: [SQL] strange query execution times

2001-10-02 Thread Tom Lane
Markus Bertheau <[EMAIL PROTECTED]> writes: > r_kunden_anbieter describes the relationship between customers and > suppliers. there are five status, 0 to 4 in attribute beziehung. both > queries return the same results. they select all customers which have a > certain relationship (beziehung = 3)

[SQL] strange query execution times

2001-10-02 Thread Markus Bertheau
Hi guys, cenes_test=# select version(); version --- PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.95.2 (1 row) cenes_test=# \d personen Table "perso