2010/7/29 Alexander Korotkov <aekorot...@gmail.com>: > But, in pg_trgm it makes it possible to combine different similarity levels > in one query. For example: > select * from test_trgm order by t <-> 'asdf' < 0.5 or t <-> 'qwer' < 0.4; > Is there any chance to handle this syntax also?
Maybe I'm missing something, but I don't think that ORDER BY clause makes much sense. OR is going to reduce a true or false value - and it's usually not that interesting to order by a column that can only take one of two values. Am I confused? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers