Postgres Pro
Downloads
Home   >   mailing lists

test aggregate functions without a dummy table - Mailing list pgsql-general

From Willy-Bas Loos
Subject test aggregate functions without a dummy table
Date
Msg-id 1dd6057e0806200434q2cc34ef3l4394133f9c19bb4e@mail.gmail.com
Whole thread Raw
Responses Re: test aggregate functions without a dummy table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Thomas Pundt
Date:
Subject: Re: Need to update all entries of one table based on an earlier backup
Next
From: Steve Clark
Date:
Subject: Re: renumber table