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 <http://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