Re: extend pgbench expressions with functions

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: extend pgbench expressions with functions
Дата
Msg-id alpine.DEB.2.10.1510301756420.6545@sto
обсуждение исходный текст
Ответ на Re: extend pgbench expressions with functions  ("Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>)
Ответы Re: extend pgbench expressions with functions  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Here is a v12 which implements the suggestions below.

> Should we not allow for functions taking 0 arguments?  Since we're already
> into some math here, how about pi()? ;-)

Hmmm, why not.

> I understand requiring at least 1 arg simplifies the code a bit, but right
> now it reports syntax error for "random()", while it correctly reports
> unexpected number of arguments for "random(1,2,3)".  We would need another
> check for min() and max() which expect >=1 arguments, but it's easy to add.

Indeed, I had to add a special check.

> I would also argue that we should rename "random" to "rand" here to avoid
> confusion with the familiar SQL function "random()" that doesn't take
> arguments.

Why not, as it is also consistent with exporand() & gaussrand().

-- 
Fabien.

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

Предыдущее
От: Kouhei Kaigai
Дата:
Сообщение: Re: [DESIGN] ParallelAppend
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Patch: Implement failover on libpq connect level.