June 22nd, 2003, 09:51 PM
|
|
Junior Member
|
|
Join Date: Oct 2002
Location: New Zealand
Posts: 8
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Convertiting MSSQL SP's Into PostgreSQL functions
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.itemName, b.extProperty, b.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.planPrioity, a.planName
ELSE
SELECT a.*, c.itemName, b.extProperty, b.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.planPrioity, a.planName
go
Can some one either post some suggestions or point me to the apporiate tutorial.
Thanks in advance
Murray
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
