Contents

/* 
 mysqlcompat-1.0b3
 public domain
 modified
 UNIX_TIMESTAMP(date)
*/

CREATE OR REPLACE FUNCTION unix_timestamp(timestamp without time zone)
RETURNS bigint AS $$
  SELECT EXTRACT(EPOCH FROM $1)::bigint
$$ VOLATILE LANGUAGE SQL;

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
ultrasphinx-1.6.7	lib/ultrasphinx/postgresql/unix_timestamp.sql
ultrasphinx-1.7	lib/ultrasphinx/postgresql/unix_timestamp.sql
ultrasphinx-1.8	lib/ultrasphinx/postgresql/unix_timestamp.sql
ultrasphinx-1.9	lib/ultrasphinx/postgresql/unix_timestamp.sql