Simple mail() function for postgresql

From: Trurl McByte <trurl(at)anything3d(dot)com>
To: pgsql-announce(at)postgresql(dot)org
Subject: Simple mail() function for postgresql
Date: 2000-12-18 11:02:11
Message-ID: Pine.LNX.4.20.0012181232580.30783-100000@trurl.anything3d.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce 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(at)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--|

Responses

Browse pgsql-announce by date

  From Date Subject
Next Message Trurl McByte 2000-12-19 10:33:11 Re: Simple mail() function for postgresql
Previous Message Michael Meskes 2000-12-16 16:32:59 Re: Great Bridge PostgreSQL products and services

Browse pgsql-general by date

  From Date Subject
Next Message Trurl McByte 2000-12-18 11:07:51 Simple mail() function for postgresql
Previous Message Leon van Dongen 2000-12-18 09:56:50 newbie question: