Re: short-cutting if sum()>constant

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: short-cutting if sum()>constant
Дата
Msg-id 28619.1261586191@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: short-cutting if sum()>constant  (Craig Ringer <craig@postnewspapers.com.au>)
Ответы Re: short-cutting if sum()>constant  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Список pgsql-sql
Craig Ringer <craig@postnewspapers.com.au> writes:
> Pavel Stehule wrote:
>> these queries are executed in some special mode, but still it is more
>> expensive than C a = a + 1

> ... and may have different rules, so you can't just write a simple "map
> expressions to C equivalents" arithmetic evaluator.

Yeah.  As an example, overflow is supposed to be caught in "a + 1",
unlike what would happen in C.

In principle you could map some of the builtin operators into inline
code, but it would be a great deal of work and the results would be
un-portable.
        regards, tom lane


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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: short-cutting if sum()>constant
Следующее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: Re: short-cutting if sum()>constant