Hello
current_timestamp is some more than less constant :)
try, please
postgres=# select extract(epoch from current_timestamp); date_part
------------------1213030028.17068
(1 row)
or
postgres=# select extract(epoch from current_timestamp)::int;date_part
------------1213030113
(1 row)
Pavel
2008/6/9 Michael Eshom <oldiesmann@oldiesmann.us>:
> I am a project manager for a popular forum system. We are adding support for
> PostgreSQL in the next version (which is currently in beta), and have added
> several PostgreSQL functions to emulate MySQL functions of the same name.
>
> I am trying to create a "UNIX_TIMESTAMP()" function in PostgreSQL, which
> will return the current timestamp. However, whenever I try to add this
> function in phpPgAdmin, it says 'Syntax error at or near ")" at character
> 28'.
>
> This is the SQL I'm using:
>
> CREATE FUNCTION unix_timestamp() RETURNS integer AS '
> SELECT current_timestamp()::int4 AS result;
> ' LANGUAGE SQL;
>
> The documentation indicates that the arguments are optional, and even shows
> an example of a function with no arguments. How can I create this function?
> --
>
> Michael Eshom
> Christian Oldies Fan
> Cincinnati, Ohio