Обсуждение: [pg_trgm] Per-query set_limit()
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.
Unfortunately, there is not a better way. You should manually set it if you want different limit. On 03.06.2016 13:43, Greg Navis wrote: > 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 > <http://www.gregnavis.com/newsletter/> > -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company