comparison: src/main/java/de/uapcore/lightpit/dao/postgres/PGVersionDao.java
src/main/java/de/uapcore/lightpit/dao/postgres/PGVersionDao.java
- changeset 62
- 833e0385572a
- parent 59
- c759c60507a2
- child 75
- 33b6843fdf8a
equal
deleted
inserted
replaced
| 61:3e287f361c7a | 62:833e0385572a |
|---|---|
| 48 public PGVersionDao(Connection connection) throws SQLException { | 48 public PGVersionDao(Connection connection) throws SQLException { |
| 49 list = connection.prepareStatement( | 49 list = connection.prepareStatement( |
| 50 "select id, project, name, ordinal, status " + | 50 "select id, project, name, ordinal, status " + |
| 51 "from lpit_version " + | 51 "from lpit_version " + |
| 52 "where project = ? " + | 52 "where project = ? " + |
| 53 "order by ordinal, name"); | 53 "order by ordinal, lower(name)"); |
| 54 | 54 |
| 55 find = connection.prepareStatement( | 55 find = connection.prepareStatement( |
| 56 "select id, project, name, ordinal, status " + | 56 "select id, project, name, ordinal, status " + |
| 57 "from lpit_version " + | 57 "from lpit_version " + |
| 58 "where id = ?"); | 58 "where id = ?"); |
