New answers tagged full-text-search
1
Postgres text search supports prefix matching:
SELECT *
FROM renns
WHERE (
to_tsvector('english', coalesce(numar_admin, '')) ||
to_tsvector('english', coalesce(nume_strada, '')) ||
to_tsvector('english', coalesce(nume_prenume, ''))||
to_tsvector('english', coalesce(bloc, '')) ||
to_tsvector('english', coalesce(apartament, ''))
) @@ ...
answered Mar 31 at 20:20
Erwin Brandstetter
130k1717 gold badges306306 silver badges450450 bronze badges
0
(A guess)
There are many queries where the results are in a predictable order even without an ORDER BY. However, this is often an artifact of the implementation and not a guaranteed ordering.
It used to be that GROUP BY automatically ordered the results as if there were a matching ORDER BY. However, the existence of that as a guarantee hobbled the ...
Top 50 recent answers are included
Related Tags
full-text-search × 543sql-server × 163
postgresql × 152
mysql × 139
index × 65
sql-server-2012 × 42
performance × 40
sql-server-2008-r2 × 34
innodb × 25
sql-server-2008 × 19
sql-server-2014 × 19
myisam × 18
pattern-matching × 18
oracle × 17
optimization × 17
query-performance × 15
database-design × 13
t-sql × 12
mariadb × 12
sql-server-2005 × 12
string-searching × 12
sql-server-2016 × 8
mysql-5.6 × 7
postgresql-performance × 7
json × 7