On 4/18/15 12:52 AM, David G. Johnston wrote:
On Friday, April 17, 2015, Suresh Raja <suresh.rajaabc@xxxxxxxxx <mailto:suresh.rajaabc@xxxxxxxxx>> wrote: Hi all: I'm looking to write a function to send email with result of a query. Is it possible to send email with in a function. Any help is appreciated. Yes...though neither the neither the sql nor the plpgsql languages have the necessary language features to do so - you will need to use something like plperlu. An (not mutually exclusive) alternative is to create an email queue and write an email sending client application to process that queue. The main advantages being loose coupling and the ability to send the emails asynchronously.
If you go that route you might find LISTEN/NOTIFY useful: http://www.postgresql.org/docs/9.4/static/sql-listen.html
-- Jim Nasby, Data Architect, Blue Treble Consulting Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
