[GENERAL] Postgres Index

2012-11-15 Thread Vishalakshi Navaneethakrishnan 
Hi all,

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

Thanks in advance..

-- 
Best Regards,
Vishalakshi.N

Re: [GENERAL] Postgres Index

2012-11-15 Thread Thomas Kellerer 

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?






--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgres Index

2012-11-15 Thread Albe Laurenz 
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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgres Index

2012-11-15 Thread Dann Corbit 
Here is the current formal definition for index creation:
http://www.postgresql.org/docs/9.2/static/sql-createindex.html


From: pgsql-general-ow...@postgresql.org 
[mailto:pgsql-general-ow...@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