George,
> i am converting an MSSQL database to Postgres. there is a lot of procedures
> to convert.
>
> which language is best for functions, SQL or plpgsql.
If you're porting from T-SQL, you should use PL/pgSQL. However, you will have
to re-code many of your procedures by hand, as T-SQL and PL/pgSQL have
substantially different syntax for control structures and cursors.
See the porting articles on techdocs.postgresql.org
> which is faster . i am using postgres 7.3.2
You should upgrade to the 7.3.4 if possible as it has some bug fixes missing
in 7.3.2.
--
Josh Berkus
Aglio Database Solutions
San Francisco
