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 6, 2017 at 7:48 | comment | added | Peter Krauss |
For to_tsvector/to_tsquery your solution lost this aspect, is complex, and slower than the "cool trick". But your solution is a good reference (!) to express any other alternative demand, when default text representation (for non-text data) is not adequate.
|
|
| Jun 6, 2017 at 7:46 | comment | added | Peter Krauss | PS: today a RDBMS as PostgreSQL can't say "that's not how SQL works"... We have XPath, JSONb algebra, etc. to work with other representations, to be friendly and competitive (!). | |
| Jun 5, 2017 at 18:42 | history | answered | Evan Carroll | CC BY-SA 3.0 |