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
|
| Список | 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 по дате отправления: