Received: from oxmail.ox.ac.uk (oxmail3.ox.ac.uk [129.67.1.180]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA71620 for ; Thu, 6 Apr 2000 09:52:53 -0400 (EDT) (envelope-from moray.mcconnachie@computing-services.oxford.ac.uk) Received: from ermine.ox.ac.uk ([163.1.2.13]) by oxmail.ox.ac.uk with esmtp (Exim 3.12 #1) id 12dChi-00029z-00; Thu, 06 Apr 2000 14:52:14 +0100 Received: from ermine.ox.ac.uk ([163.1.2.13] helo=moraypc ident=root) by ermine.ox.ac.uk with smtp (Exim 3.13 #1) id 12dChi-0002Ez-00; Thu, 06 Apr 2000 14:52:14 +0100 Message-ID: <003501bf9fcf$2776d890$760e01a3@oucs.ox.ac.uk> From: "Moray McConnachie" To: "Oscar Serrano" , "pgsql-interfaces@postgreSQL.org" References: Subject: Re: a trigger that sends an email + returning multiple records Date: Thu, 6 Apr 2000 14:51:05 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200004/38 ----- Original Message ----- From: "Oscar Serrano" To: "Moray McConnachie" ; "pgsql-interfaces@postgreSQL.org" Sent: Thursday, April 06, 2000 12:23 PM Subject: RE: [INTERFACES] a trigger that sends an email + returning 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. Sorry, the rest of the email was off-topic, but related to other discussions that people have been having on the pgsql lists in the recent past. "Incidentally" tends to imply that. Yours, Moray ---------------------------------------------------------------- Moray.McConnachie@computing-services.oxford.ac.uk