lib/ultrasphinx/postgresql/unix_timestamp.sql in ultrasphinx-1.9 vs lib/ultrasphinx/postgresql/unix_timestamp.sql in ultrasphinx-1.11
- old
+ new
@@ -4,9 +4,9 @@
public domain
modified
UNIX_TIMESTAMP(date)
*/
-CREATE OR REPLACE FUNCTION unix_timestamp(timestamp without time zone)
+CREATE FUNCTION unix_timestamp(timestamp without time zone)
RETURNS bigint AS $$
SELECT EXTRACT(EPOCH FROM $1)::bigint
$$ VOLATILE LANGUAGE SQL;