From aba0927545d3bd9998cbcf6bbc2a0b6bfd8d0318 Mon Sep 17 00:00:00 2001
From: alecpl <alec@alec.pl>
Date: Wed, 03 Mar 2010 07:12:31 -0500
Subject: [PATCH] - Fix long e-mail addresses validation (#1486453)
---
program/lib/MDB2/Driver/Function/pgsql.php | 22 +++++++++++++++++++---
1 files changed, 19 insertions(+), 3 deletions(-)
diff --git a/program/lib/MDB2/Driver/Function/pgsql.php b/program/lib/MDB2/Driver/Function/pgsql.php
index df1d455..75cad08 100644
--- a/program/lib/MDB2/Driver/Function/pgsql.php
+++ b/program/lib/MDB2/Driver/Function/pgsql.php
@@ -2,7 +2,7 @@
// +----------------------------------------------------------------------+
// | PHP versions 4 and 5 |
// +----------------------------------------------------------------------+
-// | Copyright (c) 1998-2006 Manuel Lemos, Tomas V.V.Cox, |
+// | Copyright (c) 1998-2008 Manuel Lemos, Tomas V.V.Cox, |
// | Stig. S. Bakken, Lukas Smith |
// | All rights reserved. |
// +----------------------------------------------------------------------+
@@ -42,7 +42,7 @@
// | Author: Paul Cooper <pgc@ucecom.com> |
// +----------------------------------------------------------------------+
//
-// $Id: pgsql.php,v 1.9 2006/06/12 21:48:43 lsmith Exp $
+// $Id: pgsql.php 268669 2008-11-09 19:46:50Z quipo $
require_once 'MDB2/Driver/Function/Common.php';
@@ -81,6 +81,22 @@
return $db->query($query, $types, $result_class, $result_wrap_class);
}
// }}}
+ // {{{ unixtimestamp()
+
+ /**
+ * return string to call a function to get the unix timestamp from a iso timestamp
+ *
+ * @param string $expression
+ *
+ * @return string to call a variable with the timestamp
+ * @access public
+ */
+ function unixtimestamp($expression)
+ {
+ return 'EXTRACT(EPOCH FROM DATE_TRUNC(\'seconds\', CAST ((' . $expression . ') AS TIMESTAMP)))';
+ }
+
+ // }}}
// {{{ random()
/**
@@ -96,4 +112,4 @@
// }}}
}
-?>
+?>
\ No newline at end of file
--
Gitblit v1.9.1