Re: PostGreSql equivalents to mssql

> Hi,
>    i am a novice at PostGreSQL
>    but have some idea of MsSqlServer
>
>    Migrating to PostGreSql, i need to know how capable pgsql Functions
>    are , Vis a Vis SQLServer. can pgsql functions replace all
>    functionality provided by Stored Procedures of MSSqlServer
>

Dear Adivi ,

Congratulations on choosing the most advanced  opensource database on earth.
You can expect all the support from the nice people residing here ;-)

>    specifically:
>     1. do pgsql Functions
>        a.> return datasets

yes postgresql 7.3.x  CAN
check
http://techdocs.postgresql.org/guides/SetReturningFunctions
for details.

>        b.> return output parameters

I dont get this question very much, someone else might be
able to help u here.

>
>     2. does PostGreSQL have an equivalent to Triggers of SQLServer

Yes very much,
check Triggers sections in the postgresql Documentation.

>
>
> i'd also appreciate any links to find out about
>
>    the possibility of exporting
>        data
>        relations
>        stored procs / functions / Triggers
>
>    from PostGreSQL database.


check http://techdocs.postgresql.org/#convertfrom
and specifically the
#

Microsoft SQL Server
# Converting your data from MS SQL Server 7 to PostgreSQL 7.1.x by Ryan C.
Bonham#HOWTO : Microsoft SQL Server to PostgreSQL Migration by Ian Harding

Section.



>
> Thanks In Advance
>
> regards
> -adivi



-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/