Re: PSQL commands: \quit_if, \quit_unless

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: PSQL commands: \quit_if, \quit_unless
Дата
Msg-id alpine.DEB.2.20.1612041730020.4497@lancre
обсуждение исходный текст
Ответ на Re: PSQL commands: \quit_if, \quit_unless  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: PSQL commands: \quit_if, \quit_unless  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Hello Pavel,

> Some possibilities from pgbench can have sense in psql too - generating
> some random numbers from a range.

Could you expand on the use case where this would be useful?

> In the end we use one parser for psql and for pgbench.

Note that "master" lexer is already shared, thanks to Tom, so as to detect 
consistently where a query ends.

> I agree, so step 2 should be enough, and I accept so there is opened door
> for any future enhancing.

Good, because that was the idea:-)

> We can implement some client side boolean functions (similar to pgbench
> functions that can cover often tasks: version_less, version_greather,
> user_exists, tables_exists, index_exists, variable_exists, schema_exists,

Yes, that is a possibility, but this can already be queried into a 
:-variable, so it is less indispensable.

-- 
Fabien.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [PATCH] Reload SSL certificates on SIGHUP
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: PSQL commands: \quit_if, \quit_unless