[pg_trgm] Per-query set_limit()

[Greg Navis <contact@xxxxxxxxxxxxx>]

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.

Free, biweekly scalability newsletter for SaaS CEOs