Re: extend pgbench expressions with functions

Поиск
Список
Период
Сортировка
Искать
От
Fabien COELHO
Тема
Re: extend pgbench expressions with functions
Дата
Msg-id
alpine.DEB.2.10.1510301756420.6545@sto
Ответ на
Список
Дерево обсуждения
extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Robert Haas <robertmhaas@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Heikki Linnakangas <hlinnaka@iki.fi>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions BeomYong Lee <bylee@bitnine.co.kr>
Re: extend pgbench expressions with functions BeomYong Lee <bylee@bitnine.co.kr>
Re: extend pgbench expressions with functions Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions "Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Robert Haas <robertmhaas@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Alvaro Herrera <alvherre@2ndquadrant.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Robert Haas <robertmhaas@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Robert Haas <robertmhaas@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Robert Haas <robertmhaas@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Robert Haas <robertmhaas@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Robert Haas <robertmhaas@gmail.com>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Robert Haas <robertmhaas@gmail.com>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Alvaro Herrera <alvherre@2ndquadrant.com>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Robert Haas <robertmhaas@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Robert Haas <robertmhaas@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Robert Haas <robertmhaas@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Robert Haas <robertmhaas@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Fabien COELHO <fabien.coelho@mines-paristech.fr>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Michael Paquier <michael.paquier@gmail.com>
Re: extend pgbench expressions with functions Robert Haas <robertmhaas@gmail.com>
Re: extend pgbench expressions with functions Robert Haas <robertmhaas@gmail.com>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>
Re: extend pgbench expressions with functions Fabien COELHO <coelho@cri.ensmp.fr>

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
Дата:
FAQ