Pluck not working for explicit column names #1619
* master: release 0.12.0 Remove docs, in favor of https://github.com/knex/documentation (#1666) Revert to generic pool (#1665) Fix #1619 Fix use of const in test suite for node 0.12 Moving bin/cli outside of src to allow install from master Deprecate Knex.Promise Simplifying internal client structure add With Clause (#1599) Simplify transaction classes Simplify formatter use Deprecate VERSION, update changelog Fix PG string escaping behavior (#1661)
yeah, true. I now tried that out how does it actually work. Looks like pluck() indeed has been intended to combine .select() on db server side and then plucking that selected id from result
It seems to work just as expected, but yeah it really doesn't support
yes you are right, I wanted the values of a computed column.
the table is like
The query should give me all canonical question ids available in my language.
I first tried .pluck('id') but it did not use the alias, but selected a new column.