Re: [GENERAL] Inheritance & Indexes

2003-06-25 Thread Stephan Szabo
On Wed, 25 Jun 2003, Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > I *think* 7.4 may be smarter about > > implying these conditions as well. > > Not really. AFAIR the Append-style plan is the only thing you can get > out of the planner for inheritance trees. This works well en

Re: [GENERAL] Inheritance & Indexes

2003-06-24 Thread Stephan Szabo
On Tue, 24 Jun 2003, Alan Williams wrote: > > On Tue, 24 Jun 2003, Stephan Szabo wrote: > > > hs.exon.2=> explain select * from ga_psr_transcript_1 t, > > ga_psr_exon_1e where e.parent = t.id; > > > QUERY PLAN > > > > >

Re: [GENERAL] Inheritance & Indexes

2003-06-24 Thread Alan Williams
On Tue, 24 Jun 2003, Stephan Szabo wrote: > > hs.exon.2=> explain select * from ga_psr_transcript_1 t, > ga_psr_exon_1e where e.parent = t.id; > > QUERY PLAN > > > > -

Re: [GENERAL] Inheritance & Indexes

2003-06-24 Thread Stephan Szabo
On Tue, 24 Jun 2003, Alan Williams wrote: > hs.exon.2=> \d ga_psr_transcript_1 > Table "public.ga_psr_transcript_1" > Column| Type | Modifiers > --++--- > id | integer| not null > parent