Re: Postgres Index

From: Dann Corbit <DCorbit(at)connx(dot)com>
To: 'Vishalakshi Navaneethakrishnan' <nvishalakshi(at)sirahu(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres Index
Date: 2012-11-15 11:55:23
Message-ID: 87F42982BF2B434F831FCEF4C45FC33E5BC1C6B0@EXCHANGE.corporate.connx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Here is the current formal definition for index creation:
http://www.postgresql.org/docs/9.2/static/sql-createindex.html

From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Vishalakshi Navaneethakrishnan
Sent: Thursday, November 15, 2012 3:12 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Postgres Index

Hi all,

Can we create composite index for one text column and integer column?

Thanks in advance..

--
Best Regards,
Vishalakshi.N

In response to

  • Postgres Index at 2012-11-15 11:11:38 from Vishalakshi Navaneethakrishnan

Browse pgsql-general by date

  From Date Subject
Next Message Xiaobo Gu 2012-11-15 12:31:05 How to list all schema names inside a PostgreSQL database through SQL
Previous Message Chitra Creta 2012-11-15 11:34:51 Re: Strategies/Best Practises Handling Large Tables