Excellent great info! To save the extra mailing list pings, thanks to
_everyone_ this is exactly what I was looking for.
Cheers,
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello,
I think it's easier to explain my question with example code:
CREATE TABLE t ( s VARCHAR );
CREATE TABLE
INSERT INTO t VALUES ('hello'), ('hello world');
INSERT 0 2
SELECT * FROM t;
s
-
hello
hello world
(2 rows)
SELECT s, ts_rank(vector, qu