I think there is just a few solutions.
Here is the thing. I'm modelling User entity and got to problem with searching trough user columns.
CREATE TABLE users (user_uuid uuid PRIMARY KEY,date_created timestamp,password varchar,username varchar,name varchar,first_name varchar,last_name varchar,email varchar,...) ;CREATE INDEX users__username_idx ON users (username);Now I know it's a bad practice to model sec. index on 'username' becouse of uniqness and all but what's the alternative? I'd want 'username' to be "searchable"?Tnx,
m: 040 423 688