Re: add modulo (%) operator to pgbench

Поиск
Список
Период
Сортировка
Искать
От
Fabien COELHO
Тема
Re: add modulo (%) operator to pgbench
Дата
Msg-id
alpine.DEB.2.10.1408061633200.28413@sto
Ответ на
Список
Дерево обсуждения
add modulo (%) operator to pgbench Fabien <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Robert Haas <robertmhaas@gmail.com>
Re: add modulo (%) operator to pgbench Alvaro Herrera <alvherre@2ndquadrant.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Robert Haas <robertmhaas@gmail.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Robert Haas <robertmhaas@gmail.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Robert Haas <robertmhaas@gmail.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Robert Haas <robertmhaas@gmail.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Robert Haas <robertmhaas@gmail.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Stephen Frost <sfrost@snowman.net>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Tom Lane <tgl@sss.pgh.pa.us>
Re: add modulo (%) operator to pgbench Stephen Frost <sfrost@snowman.net>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Kevin Grittner <kgrittn@ymail.com>
Re: add modulo (%) operator to pgbench Tom Lane <tgl@sss.pgh.pa.us>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Heikki Linnakangas <hlinnakangas@vmware.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Heikki Linnakangas <hlinnakangas@vmware.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Heikki Linnakangas <hlinnakangas@vmware.com>
Re: add modulo (%) operator to pgbench Robert Haas <robertmhaas@gmail.com>
Re: add modulo (%) operator to pgbench Gregory Smith <gregsmithpgsql@gmail.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Robert Haas <robertmhaas@gmail.com>
Re: add modulo (%) operator to pgbench Gregory Smith <gregsmithpgsql@gmail.com>
Re: add modulo (%) operator to pgbench Heikki Linnakangas <hlinnakangas@vmware.com>
Re: add modulo (%) operator to pgbench Andrew Dunstan <andrew@dunslane.net>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Andrew Dunstan <andrew@dunslane.net>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench David Rowley <dgrowleyml@gmail.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench David Rowley <dgrowleyml@gmail.com>
Re: add modulo (%) operator to pgbench Alvaro Herrera <alvherre@2ndquadrant.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench David Rowley <dgrowleyml@gmail.com>
Re: add modulo (%) operator to pgbench Alvaro Herrera <alvherre@2ndquadrant.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Alvaro Herrera <alvherre@2ndquadrant.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Robert Haas <robertmhaas@gmail.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Stephen Frost <sfrost@snowman.net>
Re: add modulo (%) operator to pgbench Robert Haas <robertmhaas@gmail.com>
Re: add modulo (%) operator to pgbench Robert Haas <robertmhaas@gmail.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Robert Haas <robertmhaas@gmail.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Mitsumasa KONDO <kondo.mitsumasa@gmail.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Mitsumasa KONDO <kondo.mitsumasa@gmail.com>
Re: add modulo (%) operator to pgbench Mitsumasa KONDO <kondo.mitsumasa@gmail.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: add modulo (%) operator to pgbench Mitsumasa KONDO <kondo.mitsumasa@gmail.com>
Re: add modulo (%) operator to pgbench Fabien COELHO <coelho@cri.ensmp.fr>

> Three different modulo operators seems like a lot for a language that
> doesn't even have a real expression syntax, but I'll yield to whatever
> the consensus is on this one.

Here is a third simpler patch which only implements the Knuth's modulo, 
where the remainder has the same sign as the divisor.

I would prefer this version 3 (one simple modulo based on Knuth 
definition) or if there is a problem version 2 (all 3 modulos). Version 1 
which provides a modulo compatible with C & SQL is really useless to me.

-- 
Fabien.
В списке pgsql-hackers по дате отправления
От: Fabien COELHO
Дата:
От: Robert Haas
Дата:
FAQ