Search Postgresql Archives

multi-column aggregates

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello All,

Is there any way in postgres to have an aggregate that uses input from two 
columns without using composite types?  The example we are working on is a 
first or last aggregate which requires a data value and a date column.  The 
result would be to find the latest date within the group and return the 
associated data value.  Since there may be multiple date columns each with 
dependent columns, we can't use a sort by date and a simpler first or last 
aggregate.

Thanks,

-Chris
-- 
Chris Kratz


[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]
  Powered by Linux