Postgres Index

Vishalakshi Navaneethakrishnan, 15.11.2012 12:11:

Hi all,

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

Yes of course. What happened when you tried?

Vishalakshi Navaneethakrishnan wrote:

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

Yes.

It would probably have been faster to try it than
to send this e-mail...

Yours,
Laurenz Albe

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

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Vishalakshi Navaneethakrishnan
Sent: Thursday, November 15, 2012 3:12 AM
To: pgsql-general@postgresql.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