What does the INDEX-expression do? An example at the end:

CREATE TABLE tags (
  tag_id                       varchar(255) NOT NULL, 
  "{Users}{userID}question_id" int4 NOT NULL, 
  tag                          varchar(20), 
  CONSTRAINT tag 
    PRIMARY KEY (tag_id));
CREATE INDEX tags_tag 
  ON tags (tag);
postgresql indexing
Edit
Report