PostgreSQL - CREATE INDEX on an element of TYPE

Question

I would like to create an index in an element of specific type.

Can you help me ? Thanks

CREATE TYPE taddress AS (
 street1 varchar,
 street2 varchar,
 zipcode varchar,
 city varchar
);

CREATE TABLE person (
    id serial primary key,
    firstname varchar not null,
    lastname varchar not null,
    address taddress);

CREATE INDEX idx_street1 ON person ((address).street2); -- <- Doesn't work !!

vyegorov · Accepted Answer · 2012-07-04 08:09:10Z

1

Please, try this:

CREATE INDEX idx_street1 ON person (((address).street2));

And include a full error message if this doesn't works for you.

answered Jul 4, 2012 at 8:09

vyegorov

23k7 gold badges61 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL - CREATE INDEX on an element of TYPE

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related