[DBIx-Class-Devel] [dbsrgits/sql-translator] Support Expressions as index fields (Issue #159)

[Veesh Goldman]

              @rabbiveesh As you design that, an interesting unit test for postgres to really test the boundaries would be

```
create table test (name varchar(50) not null);
create index ix_test2 on test (substr(name, 2, 3) desc, substr(name, 5, 3) asc);
```

:-)

_Originally posted by @nrdvana in https://github.com/dbsrgits/sql-translator/issues/68#issuecomment-1601575733_

There are a few more comments in that PR's discussion. (will past them back here).

Another thought - when parsing the fields, sqlt **helpfully** splits strings on commas. So we're actually going to have to only support that via a hashref arg (as mentioned there)
            

-- 
Reply to this email directly or view it on GitHub:
https://github.com/dbsrgits/sql-translator/issues/159
You are receiving this because you are subscribed to this thread.

Message ID: <dbsrgits/sql-translator/issues/159 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class-devel/attachments/20230621/d85e559e/attachment.htm>