On Wed, Jul 07, 2010 at 01:53:25PM +0000, Matthew Wilson wrote: > create table scheduled_email ( > to_address text, > email_subject text, > email_body text, > deliver_at timestamp, > sent boolean > ); > > I know I could write an external process to poll this table and select > all rows where deliver_at < current_timestamp and sent = 'f'. > > But is there some other way inside postgresql that will do something > similar? I would want something like listen/notify, where postgres > starts an external process when any data exist.
You could have a trigger tell you when the first item to be delivered changes. I'd still be tempted to keep the waiting outside the database. -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
