Hello 2008/5/10 Ivan Sergio Borgonovo <mail@xxxxxxxxxxxxxxx>: > On Sat, 10 May 2008 07:35:36 +0200 > "Pavel Stehule" <pavel.stehule@xxxxxxxxx> wrote: > >> your application different execution paths. Generally I can say, so >> plpgsql isn't well language for this games, and better is using >> plperl, plpython or other external language. > > It is clear what is at least one of the advantage of plpython or > plperl over plpgsql, but then what are the advantages of plpgsql over > the rest of the crowd other than resembling the language used in > Oracle? > SQL integration and compatibility with PostgreSQL. PL/pgSQL uses PostgreSQL expression evaluation - so all PostgreSQL functions are simply accessible from plpgsql. Next - plpgsql variables are compatible (are same) with PostgreSQL internal datatypes - so you don't need any conversion between Postgres and plpgsql. plpgsql is best glue of SQL statements. Pavel > -- > Ivan Sergio Borgonovo > http://www.webthatworks.it > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
