Re: pl/PgSQL, variable names in NEW

From: Martin Edlman <edlman(at)fortech(dot)cz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: pl/PgSQL, variable names in NEW
Date: 2008-04-10 11:34:06
Message-ID: 47FDFB2E.3060503@fortech.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers pgsql-sql

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

|> I don't want to rewrite whole trigger to plPerl as I would have to use
|> DBD-PgSPI.
|
| Huh? Certainly not -- there are functions in PL/Perl for this. See
| spi_exec_query in
| http://www.postgresql.org/docs/8.3/static/plperl-database.html

Oh, I see. I have read the doc "...can be done via the function
spi_exec_query described below, or via an experimental module
DBD::PgSPI...", but missed the "OR" and thought that DBD::PgSPI is
mandatory.
Thanks.

Martin

- --
Regards,

Martin Edlman
Fortech, spol. s r.o,
Ropkova 51, 57001 Litomyšl
Public GPG key: http://edas.visaci.cz/#gpgkeys
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFH/fstqmMakYm+VJ8RAjLSAKCW4rqz2w1CaND8/BxAxLcOlwwziQCgjxsA
PAAPqST5r5St08OgJsVkVK4=
=ZUKV
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Alvaro Herrera 2008-04-10 13:16:02 Re: [SQL] pl/PgSQL, variable names in NEW
Previous Message Decibel! 2008-04-09 20:31:47 Patch for pg_backend_pid

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2008-04-10 12:05:31 Re: Free Space Map data structure
Previous Message PFC 2008-04-10 11:20:11 Dumb Micro-Optimization

Browse pgsql-sql by date

  From Date Subject
Next Message Volkan YAZICI 2008-04-10 12:37:13 Re: dateformat issue
Previous Message Tk421 2008-04-10 11:19:42 Re: dateformat issue