| From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "Martin Gainty" <mgainty(at)hotmail(dot)com> |
| Cc: | walterbyrd <walterbyrd(at)iname(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Sun acquires MySQL |
| Date: | 2008-01-20 17:04:25 |
| Message-ID: | 162867790801200904i30d6adaci112123c6311e6f13@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello
>
> support for compiling and execution of Procedures in Postgres is nonexistent
> 99% of SQL code in either Oracle and MySQL DB's are written in
> Procedures..trying to port that to Postgres is a very long and tedious
> uphill climb
>
true compilation is necessary only for some cases (note: MySQL stored
procedures are not compiled too ~ PostgreSQL has similar language
plpgpsm with little bit faster execution
(http://www.pgsql.cz/index.php/SQL/PSM_Manual ). When plpgsql is
potentially slow, you can use perl or write own custom function in C,
what is simpler than with Oracle.
Regards
Pavel Stehule
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2008-01-20 17:24:11 | Re: [GENERAL] SHA1 on postgres 8.3 |
| Previous Message | Joshua D. Drake | 2008-01-20 17:00:39 | Re: postgres.org src build vs. enterprisedb installer |