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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org