Simple mail() function for postgresql - Mailing list pgsql-general

From Trurl McByte
Subject Simple mail() function for postgresql
Date
Msg-id Pine.LNX.4.20.0012181307190.30783-100000@trurl.anything3d.com
Whole thread Raw
List pgsql-general
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--|



pgsql-general by date:

Previous
From: Karel Zak
Date:
Subject: Re: [HACKERS] Trigger
Next
From: "Feng Xue"
Date:
Subject: Re: a "huge" table with small rows and culumns