Re: [GENERAL] [SQL] function to send email with query results

2015-04-19 Thread Anil Menon
Using Apache camel Listen/notify ->PGEvent Component (http://camel.apache.org/pgevent.html) -> Mail Component (http://camel.apache.org/mail.html) You can also then handle all the exceptions of the email server easily. On Sun, Apr 19, 2015 at 6:42 AM, Jim Nasby wrote: > On 4/18/15 12:52 AM, Dav

Re: [GENERAL] [SQL] function to send email with query results

2015-04-18 Thread Jim Nasby
On 4/18/15 12:52 AM, David G. Johnston wrote: On Friday, April 17, 2015, Suresh Raja mailto:suresh.raja...@gmail.com>> 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 appreciate

Re: [GENERAL] [SQL] function to send email with query results

2015-04-17 Thread David G. Johnston
On Friday, April 17, 2015, Suresh Raja 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