From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: function to send email with query results |
Date: | 2015-04-18 11:04:32 |
Message-ID: | 20150418110432.GA12157@tux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
Suresh Raja <suresh(dot)rajaabc(at)gmail(dot)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 appreciated.
Only with functions written in untrusted languages, for instance pl/sh or
pl/perlU. Not with pure SQL, no with pl/pgsql or similar.
Consider: you can't rollback a conveyed mail.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Nasby | 2015-04-18 22:37:25 | Re: "Cast" SRF returning record to a table type? |
Previous Message | John R Pierce | 2015-04-18 06:57:42 | Re: function to send email with query results |
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Nasby | 2015-04-18 22:42:01 | Re: [SQL] function to send email with query results |
Previous Message | John R Pierce | 2015-04-18 06:57:42 | Re: function to send email with query results |