| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | "George A(dot)J" <jinujosein(at)yahoo(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Which is faster SQL or PL/PGSQL |
| Date: | 2003-10-20 05:29:40 |
| Message-ID: | 200310192229.40259.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kumar | 2003-10-20 06:28:27 | Max input parameter for a function |
| Previous Message | Christopher Browne | 2003-10-20 03:48:38 | Re: Which is faster SQL or PL/PGSQL |