Postgres Pro
Downloads
Home   >   mailing lists

Re: Not using index - Mailing list pgsql-general

From Crispin Miller
Subject Re: Not using index
Date
Msg-id 3A817A5B.5742022A@cs.man.ac.uk
Whole thread Raw
In response to Not using index  (Crispin Miller <crispin@cs.man.ac.uk>)
List pgsql-general
Tree view 
Hi Tom, Jeorg,
Thanks for the help - I thought I might be being a bit vague...
Jeorg's suggestion solved my problem - I need to create an index across
both  columns:

'create index foo on bar ( baz, bang )'

Like what Jeorg said I should :-)

Appreciated,
Crispin

pgsql-general by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?
Next
From: Brice Ruth
Date:
Subject: Re: Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?