[pg_trgm] Per-query set_limit() - Mailing list pgsql-general

From Greg Navis
Subject [pg_trgm] Per-query set_limit()
Date
Msg-id CAA6WWt-1Z=vVyj3f4wD57ZWuOz39+mJ-6H3mDTAwOVVTBcVcZw@mail.gmail.com
Whole thread Raw
Responses Re: [pg_trgm] Per-query set_limit()
List pgsql-general
Hey!

I'd like to call `set_limit` on a per-query basis, i.e. searching for restaurants in a given city should use 0.4 and searching for cinemas by name should use 0.2. I can accomplish this with:

```
SELECT set_limit(0.2);
SELECT * FROM cinemas WHERE name % ?;
```

(similarly for restaurants).

My question is: is there a better way?

Best regards
--
Greg Navis
I help tech companies to scale Heroku-hosted Rails apps.

pgsql-general by date:

Previous
From: Greg Navis
Date:
Subject: [pg_trgm] Making similarity(?, ?) < ? use an index
Next
From: Artur Zakirov
Date:
Subject: Re: [pg_trgm] Making similarity(?, ?) < ? use an index