Postgres Pro
Downloads
Home   >   mailing lists

Re: Composite Indexes with a function and a column - Mailing list pgsql-general

From Christian Hammers
Subject Re: Composite Indexes with a function and a column
Date
Msg-id 20121221131214.692c1aaa@sys-251.netcologne.de
Whole thread Raw
In response to Composite Indexes with a function and a column  (Alex Pires de Camargo <acamargo@gmail.com>)
Responses Re: Composite Indexes with a function and a column  (Alex Pires de Camargo <acamargo@gmail.com>)
List pgsql-general
Tree view 
Hello

On Fri, 21 Dec 2012 08:46:14 -0200
Alex Pires de Camargo <acamargo@gmail.com> wrote:

> Is it possible?
>
>    Thanks!

Why not?

 devel_np=# CREATE TABLE t (i int);
 CREATE TABLE

 devel_np=# CREATE INDEX ON t (length(i::text), i);
 CREATE INDEX

bye,

-christian-

pgsql-general by date:

Previous
From: Alex Pires de Camargo
Date:
Subject: Composite Indexes with a function and a column
Next
From: Alex Pires de Camargo
Date:
Subject: Re: Composite Indexes with a function and a column