Re: [GENERAL] Getting input from email...

1998-10-26 Thread Mike Meyer
On Mon, 26 Oct 1998, Herouth Maoz wrote: > At 18:09 +0200 on 26/10/98, Dan Delaney wrote: > >I'd like to set up a DB using postgreSQL to archive a > > mailing list. How would I go about getting all of the mail > > sent to the list to be automatically entered into the > > database when it is se

No Subject

1998-10-26 Thread Doug Smith
Does anybody know if 'LEFT','RIGHT','SUBSTR' are working with psql, I keep getting the magical parse error at or near 'left'. Thanks  

Re: [GENERAL] Getting input from email...

1998-10-26 Thread Christophe Pettus
I do something of that sort right now to support an email notification service. Rather than use Procmail, I use scripts written in Perl which accept a message, parse it up using the Mail::Internet and Mail::Address modules, and then insert it into the database. Works like a charm. At 08:09 AM 1

Re: [GENERAL] Getting input from email...

1998-10-26 Thread Benjamin Gonay
Hi all, On Mon, 26 Oct 1998, Dan Delaney wrote: > Hi all. >I'd like to set up a DB using postgreSQL to archive a > mailing list. How would I go about getting all of the mail > sent to the list to be automatically entered into the > database when it is sent? I assume I would need to set up an

Re: [GENERAL] Getting input from email...

1998-10-26 Thread Herouth Maoz
At 18:09 +0200 on 26/10/98, Dan Delaney wrote: >I'd like to set up a DB using postgreSQL to archive a > mailing list. How would I go about getting all of the mail > sent to the list to be automatically entered into the > database when it is sent? I assume I would need to set up an > email ad

[GENERAL] Getting input from email...

1998-10-26 Thread Dan Delaney
Hi all. I'd like to set up a DB using postgreSQL to archive a mailing list. How would I go about getting all of the mail sent to the list to be automatically entered into the database when it is sent? I assume I would need to set up an email address for the list to send to, something like "[EMA

Re: [GENERAL] select and join

1998-10-26 Thread Ulf Mehlig
Morelli 'ZioBudda' Davide Michel wrote: > My question is: there is a way to join the table "utente" so to make a > "select" that return me the column "utente.cognome",too ? > > i have make this try: > > esame=> select utente.cognome, >prestito.id_utente, >lib

Re: [GENERAL] date null

1998-10-26 Thread Ulf Mehlig
Morelli 'ZioBudda' Davide Michel wrote: > Hi, how can control in a "select" if a date is not null? [...] I > want to select only tuples in which notifica1 or notifica2 or > notifica3 are not null. did you try the following? select * from prestito where notifica1 is not null or