test aggregate functions without a dummy table
От
Willy-Bas Loos
Тема
test aggregate functions without a dummy table
Дата
Msg-id
1dd6057e0806200434q2cc34ef3l4394133f9c19bb4e@mail.gmail.com
Список
Дерево обсуждения
test aggregate functions without a dummy table "Willy-Bas Loos" <willybas@gmail.com>
Re: test aggregate functions without a dummy table Tom Lane <tgl@sss.pgh.pa.us>
Re: test aggregate functions without a dummy table Michael Fuhr <mike@fuhr.org>
Hi,
I want to test the behavior of an an aggregate without creating a dummy table for it.
But the code for it is horrible.
Is there no simpler way?
select max(foo)
from (select 1 as foo union select 2 as foo)bar;
thx
I want to test the behavior of an an aggregate without creating a dummy table for it.
But the code for it is horrible.
Is there no simpler way?
select max(foo)
from (select 1 as foo union select 2 as foo)bar;
thx
В списке pgsql-general по дате отправления
От: Thomas Pundt
Дата:
