Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgres Index

Postgres Index

From
Vishalakshi Navaneethakrishnan
Date:
Hi all,

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

Thanks in advance..

--
Best Regards,
Vishalakshi.N

Re: Postgres Index

From
Thomas Kellerer
Date:
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?

Re: Postgres Index

From
"Albe Laurenz"
Date:
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

Re: Postgres Index

From
Dann Corbit
Date:

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