Postgres Pro
Downloads
Home   >   mailing lists

how to get compound indexes - Mailing list pgsql-general

From John fabiani
Subject how to get compound indexes
Date
Msg-id 6u_D7.5073$HZ.252615@sjcpnn01.usenetserver.com
Whole thread Raw
List pgsql-general
Tree view 
Hi,
Is it possible to have compound indexes?  As in
Create index glacnt1 on glacnt(glacnt+yearprd);

I would like to combine two strings as the index.

John

pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: SQL question
Next
From: Jeff Eckermann
Date:
Subject: Re: Best way to store/search phone numbers?