New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

function in unique index [feature request] #14965

Closed

aunz opened this issue Apr 16, 2017 · 1 comment

aunz commented Apr 16, 2017

create table users (
  id int primary key,
  name string,
  email string,
  unique (lower(email)) -- this throws an error
);
create unique index on users (lower(email));  -- this also throws an error

Would be nice to have, as postgreSQL supports this

Member

jordanlewis commented Apr 17, 2017

Thanks for the suggestion! This feature is known as computed indexes, which we're tracking in issue #9682 already. I'm closing this as a duplicate.

jordanlewis closed this as completed

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment