Thread: Simple mail() function for postgresql

Hi.

Simple mail() function for postgresql,
very usefull in triggers (autologging via email, autoinvoice, email orders,
PBeM games and more
other).

ftp://ftp.trurl.anything3d.com/pub/Linux/our/mail.tar.gz
or
http://ftp.trurl.anything3d.com/Linux/our/mail.tar.gz

using: mail(to::varchar, subject::varchar, message::varchar, headers::varchar)
returns: 'true'::bool if all right, else is 'false'::bool

sample: select mail('root@localhost', 'Test', 'Ooops!!!', '');


PS. Don't use NULL in fields.
PPS. For UNIX-like system only now.


--
      Trurl McByte, Capt. of StasisCruiser "Prince"
|InterNIC: AR3200                   RIPE: AR1627-RIPE|
|--98 C3 78 8E 90 E3 01 35  87 1F 3F EF FD 6D 84 B3--|

On Mon, 18 Dec 2000 (Yesterday), Trurl McByte wrote:

  TM> Hi.
  TM>
  TM> Simple mail() function for postgresql,
  TM> very usefull in triggers (autologging via email, autoinvoice, email orders,
  TM> PBeM games and more
  TM> other).
  TM>
  TM> ftp://ftp.trurl.anything3d.com/pub/Linux/our/mail.tar.gz
  TM> or
  TM> http://ftp.trurl.anything3d.com/Linux/our/mail.tar.gz
  TM>
  TM> using: mail(to::varchar, subject::varchar, message::varchar, headers::varchar)
  TM> returns: 'true'::bool if all right, else is 'false'::bool
  TM>
  TM> sample: select mail('root@localhost', 'Test', 'Ooops!!!', '');
  TM>
  TM>
  TM> PS. Don't use NULL in fields.

NULL value error in fields fixed, empty & NULL values processing normally
now.

Package have a new name: pgsendmail
and location now
ftp://ftp.trurl.anything3d.com/pub/Linux/our/pgsendmail.tar.gz
or
http://ftp.trurl.anything3d.com/Linux/our/pgsendmail.tar.gz
(old location correct too)

  TM> PPS. For UNIX-like system only now.
  TM>
  TM>
  TM>

--
      Trurl McByte, Capt. of StasisCruiser "Prince"
|InterNIC: AR3200                   RIPE: AR1627-RIPE|
|--98 C3 78 8E 90 E3 01 35  87 1F 3F EF FD 6D 84 B3--|