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:klimpong@gmail.com] 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 Dalibor.Andzakovic@swerve.co.nz 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/