Received: from fondos.net ([216.247.232.112])
	by hub.org (8.9.3/8.9.3) with ESMTP id HAA52452
	for <pgsql-interfaces@postgresql.org>;
	Thu, 6 Apr 2000 07:24:11 -0400 (EDT)
	(envelope-from oserra@fondos.net)
Received: from p500windows (rad120136.radius.teleline.es [195.235.120.136]
	(may be forged)) by fondos.net (8.9.3/8.9.3) with SMTP id NAA15347;
	Thu, 6 Apr 2000 13:24:48 +0200
From: "Oscar Serrano" <oserra@fondos.net>
To: "Moray McConnachie" <moray.mcconnachie@computing-services.oxford.ac.uk>,
	"pgsql-interfaces@postgreSQL.org" <pgsql-interfaces@postgresql.org>
Subject: RE: a trigger that sends an email + returning multiple records
Date: Thu, 6 Apr 2000 13:23:57 +0200
Message-ID: <NDBBKNFDELOHICEHIMGGMELGCCAA.oserra@fondos.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
In-Reply-To: <00c101bf9fb8$89107820$760e01a3@oucs.ox.ac.uk>
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Importance: Normal
X-Archive-Number: 200004/37



> -----Mensaje original-----
> De: Moray McConnachie
> [mailto:moray.mcconnachie@computing-services.oxford.ac.uk]
> Enviado el: jueves, 06 de abril de 2000 13:09
> Para: Oscar Serrano; pgsql-interfaces@postgreSQL.org
> Asunto: Re: [INTERFACES] a trigger that sends an email + returning
> multiple records
>
>
> 7.0 provides support for calling Perl functions, although I
> haven't had time
> to experiment with it. In beta4 (not sure about earlier betas), it can be
> found in the src/interfaces/perl5 directory, with examples in the eg
> subdirectory beneath that...
> Looks pretty good, although I guess it still can't return
> multiple records.

This sounds really interesting. I will have to try it.

But I don't really undertand the rest of the email. I do not need
a function that returns any record. It just must open the sendmail and
send an email. And it must be done each time a record is inserted on
a table.

> Incidentally, I've just thought of a work around for not being able to
> return multiple records, although I'm not sure how exactly it would work.
> Could one have a function that would create a table with (e.g.) a random
> time-based name, fill it with the desired records, and return the name of
> the table as the result of the argument?
>
> Could one do for example, something like
>
> SELECT searchid FROM searchfunction('criteria1','criteria2','criteria3')
>
> or is that going to be rejected because you can't have functions returning
> tablenames?
>
> Haven't got time to look at any of this :-<
> Yours,
> Moray
> ----------------------------------------------------------------
> Moray.McConnachie@computing-services.oxford.ac.uk
> ----- Original Message -----
> From: "Oscar Serrano" <oserra@fondos.net>
> To: "pgsql-interfaces@postgreSQL.org" <pgsql-interfaces@postgresql.org>
> Sent: Thursday, April 06, 2000 9:50 AM
> Subject: [INTERFACES] a trigger that sends an email
>
>
> > Hi:
> >
> > I need to do something special.
> > I need that when a new record is inserted in one of my tables,
> the system
> > sends an email.
> > I thing I need to create a trigger. And I thing I need to create a
> function
> > that sends an email.
> > Is it possible?
> > May I do the function that sends the email in Perl?
> >
> > Any idea?
> >
> > Thank you very much.
> >
> >
> >