On Tue, 11 May 1999, Bruce Momjian wrote:
> Date: Tue, 11 May 1999 12:04:32 -0400 (EDT)
> From: Bruce Momjian <maillist@candle.pha.pa.us>
> To: Oleg Bartunov <oleg@sai.msu.su>
> Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgreSQL.org
> Subject: Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604
>
> > 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?
>
Oh, yes.
Oleg
> --
> 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, Pennsylvania 19026
>
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83