[GENERAL] oracle rank() over partition by queries

Hi, Is there a way to get the oracle's rank() over partition by queries in postgresql? For example if I have a query like Select Col1, Col2, RANK() OVER(PARTITION BY Col1 order by Col3 desc) as rank from table1 Thanks in advance

[GENERAL] pgpool II question

Hi, Im a newbie to postgres. Can you explain what pgpool is ? Thanks

[GENERAL] pgpool and foreign key on partitioned tables

Hi, Does pgpool II support foreign key constraints on partitions? If so, how? Thanks