Search Postgresql Archives
test aggregate functions without a dummy table
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
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
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]