If I understand you correctly, for the length of the transaction. SELECT unix_timestamp(now());
is identical to BEGIN; SELECT EXTRACT(EPOCH FROM CURRENT_TIMESTAMP); COMMIT; dali > -----Original Message----- > From: till [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 13 February 2008 10:51 > To: Dalibor Andzakovic > Cc: RoundCube Dev > Subject: Re: [RCD] check.php (installer-light) > > On Feb 12, 2008 10:28 PM, Dalibor Andzakovic > <[EMAIL PROTECTED]> wrote: > > One fix for PostgreSQL would be to declare a function. > > > > Something like: > > > > CREATE FUNCTION unix_timestamp (timestamptz) RETURNS numeric AS > > $BODY$ > > BEGIN > > RETURN EXTRACT(EPOCH FROM $1); > > END; > > $BODY$ > > LANGUAGE plpgsql; > > > > Would do the job. > > Dali, > > just out of curiousity - for how long does this "persist" in > PostgreSQL? > > Thanks, > Till _______________________________________________ List info: http://lists.roundcube.net/dev/
