equivalent in postgres of over(partition) function in db2

["vinita bansal" <sagivini@xxxxxxxxxxx>]

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.


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend