Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackerspgsql-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

pgsql-docs by date

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

pgsql-hackers by date

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

pgsql-sql by date

Next:From: Volkan YAZICIDate: 2008-04-10 12:37:13
Subject: Re: dateformat issue
Previous:From: Tk421Date: 2008-04-10 11:19:42
Subject: Re: dateformat issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group