> On Mon, 10 May 1999, Bruce Momjian wrote:
>
> > Date: Mon, 10 May 1999 12:48:15 -0400 (EDT)
> > From: Bruce Momjian <maillist@candle.pha.pa.us>
> > To: Tom Lane <tgl@sss.pgh.pa.us>
> > Cc: Oleg Bartunov <oleg@sai.msu.su>, pgsql-hackers@postgreSQL.org
> > Subject: Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604
> >
> >
> > Is this a valid item?
> >
>
> After compilation of current cvs at home I test this and it works.
> But explain shows that select will not use indices, which exists !
> select station_id from metro_stations except select metro_id from work_flats;
Indexes aren't much use if you don't have a WHERE restriction, no?
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026