Re: PostgreSQL <> MySQL: first draft - Mailing list pgsql-advocacy

From Sean Chittenden
Subject Re: PostgreSQL <> MySQL: first draft
Date
Msg-id 20030915182504.GA45649@perrin.nxad.com
Whole thread Raw
In response to PostgreSQL <> MySQL: first draft  (Ian Barwick <barwick@gmx.net>)
Responses Way cool article  (Josh Berkus <josh@agliodbs.com>)
List pgsql-advocacy
> Stored Procedures
> -----------------
>
> Stored procedures are blocks of code stored and executed in
> the database backend. They are typically created in an SQL-like procedural
> language or a fourth-generation language such as Java or Perl.
>
> - MySQL has no support for any form of stored procedure. Implementation
>   is planned at an unspecified future date:
>     http://www.mysql.com/doc/en/ANSI_diff_Triggers.html
>
> - PostgreSQL provides  mature and tested support  for function creation
>   in SQL and the following procedural languages:
>    PL/PgSQL (PostgreSQL's own procedural language, similar
>               to e.g. Oracle's PL/SQL)
>     Perl
>     Python
>     Tcl

pl/ruby exists too:

http://moulon.inra.fr/ruby/plruby.html

-sc

--
Sean Chittenden

pgsql-advocacy by date:

Previous
From: Josh Berkus
Date:
Subject: Re: PostgreSQL <> MySQL: missing the point?
Next
From: Josh Berkus
Date:
Subject: Way cool article