Re: Composite Indexes with a function and a column

From: Christian Hammers <ch(at)lathspell(dot)de>
To: Alex Pires de Camargo <acamargo(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Composite Indexes with a function and a column
Date: 2012-12-21 12:12:14
Message-ID: 20121221131214.692c1aaa@sys-251.netcologne.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

On Fri, 21 Dec 2012 08:46:14 -0200
Alex Pires de Camargo <acamargo(at)gmail(dot)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-

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Pires de Camargo 2012-12-21 12:31:43 Re: Composite Indexes with a function and a column
Previous Message Alex Pires de Camargo 2012-12-21 10:46:14 Composite Indexes with a function and a column