Обсуждение: [pg_trgm] Per-query set_limit()

Поиск
Список
Период
Сортировка

[pg_trgm] Per-query set_limit()

От
Greg Navis
Дата:
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.

Re: [pg_trgm] Per-query set_limit()

От
Artur Zakirov
Дата:
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