Expression indexes in Postgres #213

Closed
pikajude opened this Issue Feb 7, 2014 · 3 comments

Comments

Projects
None yet
3 participants
@pikajude
Contributor

pikajude commented Feb 7, 2014

I'm working on a project where records need to have uniqueness enforced according to lower(name). It would be useful if data instances for Unique could be instantiated to expressions on columns rather than just column names.

User
  name Text
  UniqueName name expr=lower(name)
@gregwebs

This comment has been minimized.

Show comment Hide comment
@gregwebs

gregwebs Feb 7, 2014

Owner

Maybe this can potentially help?
https://github.com/jcristovao/migrationplus

Owner

gregwebs commented Feb 7, 2014

Maybe this can potentially help?
https://github.com/jcristovao/migrationplus

@pikajude

This comment has been minimized.

Show comment Hide comment
@pikajude

pikajude Feb 7, 2014

Contributor

Looks like that doesn't support advanced postgres indexes. Also, I don't think that will change the data instance for Unique. The first one I can fix myself by writing a manual index creation as part of the application startup, but the second, after looking at the definition of Unique, seems (currently) impossible.

Contributor

pikajude commented Feb 7, 2014

Looks like that doesn't support advanced postgres indexes. Also, I don't think that will change the data instance for Unique. The first one I can fix myself by writing a manual index creation as part of the application startup, but the second, after looking at the definition of Unique, seems (currently) impossible.

@gregwebs gregwebs added the Postgres label Aug 4, 2014

@snoyberg

This comment has been minimized.

Show comment Hide comment
@snoyberg

snoyberg Jul 19, 2015

Owner

Closing out old issues, please reopen if still relevant

Owner

snoyberg commented Jul 19, 2015

Closing out old issues, please reopen if still relevant

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