New answers tagged

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, '')) ) @@ ...


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