Re: Which is faster SQL or PL/PGSQL

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