Postgresql and connect by

Hi!

is there any function in postgres like it is in oracle “connect by”?

yes, use a recursive common table expression (CTE)

see http://wiki.postgresql.org/wiki/CTEReadme