how to get compound indexes

From: John fabiani <jfabiani(at)yolo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to get compound indexes
Date: 2001-10-31 21:54:37
Message-ID: 6u_D7.5073$HZ.252615@sjcpnn01.usenetserver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Gould 2001-10-31 22:25:16 Re: Postgresql Copy
Previous Message Nick Fankhauser 2001-10-31 20:03:23 Re: fresh install of postgres 7.1 doesn't start postmaster with the "-i" flag