Timeline for Search all columns as a single text per row
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 8, 2017 at 20:23 | comment | added | jjanes | This is a neat trick, but the problem is that it is hard to index, as foo::text is not immutable. What I did in a similar situation is create a pl/perl function which returns the concatenation of all column values (minus a couple which it made not sense to search) with a suitable delimiter and falsely mark it as immutable, then index the results of that function. | |
| Jun 6, 2017 at 7:25 | vote | accept | Peter Krauss | ||
| Jun 5, 2017 at 20:46 | history | answered | user1822 | CC BY-SA 3.0 |