title: Postgres analogue to CROSS APPLY in SQL Server
body: <p>I need to migrate SQL queries written for MS SQL Server 2005 to Postgres 9.1.<br>
  What is the best way to substitute for <code>CROSS APPLY</code> in this query? </p>
  
  <pre><code>SELECT *
  FROM V_CitizenVersions         
  CROSS APPLY     
         dbo.GetCitizenRecModified(Citizen, LastName, FirstName, MiddleName,
  BirthYear, BirthMonth, BirthDay, ..... ) -- lots of params
  </code></pre>
  
  <p><code>GetCitizenRecModified()</code> function is a table valued function. I can't place code of this function because it's really enormous, it makes some difficult computations and I can't abandon it.</p>