Re: create index on a field of udt

On 6/28/2015 10:08 PM, Shujie Shang wrote:

create type info as (id int, name text);

I want to create index on info.id.

you can't create an index on a type, just on a table.

    create table info (id serial primary key, name text);

or

    create table info (id serial, name text);
    alter table info add primary key(id);

or more generically,

    create index on some_table ( some_field[,...] ) ;

(a primary key is a unique not null constraint, this implies an index in postgresql)

-- 
john r pierce, recycling bits in santa cruz