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

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, libro.tipo,

[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

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

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 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

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 sent? I