HI.
I would like to know if the syntax and layout of PostgreSQL functions are the same or similar to the Stored Procedures of MSSQL.

Here is an Example of one of the MSSQL Stored Procedures that I am trying to convert.

PHP Code:
IF EXISTS(SELECT name FROM sysobjects
      WHERE name 
'sp_HostingLoadAll' AND type 'P')
   
DROP PROCEDURE sp_HostingLoadAll
GO
create proc sp_HostingLoadAll
    
@PlanPub int null
as
    IF ( @
PlanPub is null )
        
SELECT a.*, c.itemNameb.extPropertyb.extPropertyDesc
        FROM dbo
.dbt_hosting_plan_names a INNER JOIN
            dbo
.dbt_hosting_plan b ON a.uid b.plan_id INNER JOIN
            dbo
.dbt_plan_items c ON b.item_id c.uid
        ORDER BY a
.planPrioitya.planName
    
ELSE
        
SELECT a.*, c.itemNameb.extPropertyb.extPropertyDesc
        FROM dbo
.dbt_hosting_plan_names a INNER JOIN
            dbo
.dbt_hosting_plan b ON a.uid b.plan_id INNER JOIN
            dbo
.dbt_plan_items c ON b.item_id c.uid
        where a
.planPublic = @PlanPub
        ORDER BY a
.planPrioitya.planName

go 
Can some one either post some suggestions or point me to the apporiate tutorial.

Thanks in advance
Murray