equivalent in postgres of over(partition) function in db2 - Mailing list pgsql-general

Hi,

I have the following query in db2:

"insert into xyz (a,b) select 10, MIN(CM_LEDGERITEM.tril_gid) OVER(PARTITION
BY CM_LEDGERITEM.MMPAYEE, CM_PROMOTION.MMCOMPTYPE, CM_LEDGERITEM.MODEL) from
...."

I am not able to find a corresponding thing for min(...) over(partition by
col1, col2, col3..)
in postgres.What will be its equivalent in postgres??

Regards,
Vinita Bansal

_________________________________________________________________
Manage information better. Optimise your tasks.
http://www.microsoft.com/india/office/experience/  Experience MS Office
System.