From: | Mark Roberts <mailing_lists(at)pandapocket(dot)com> |
---|---|
To: | Michael Eshom <oldiesmann(at)oldiesmann(dot)us> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Unable to create function which takes no arguments |
Date: | 2008-06-09 16:46:42 |
Message-ID: | 1213030002.9666.22.camel@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
IIRC, current_timestamp doesn't require parens. You could try something
like this:
select extract(epoch from current_timestamp)::int4 as result;
-Mark
On Mon, 2008-06-09 at 12:05 -0400, Michael Eshom wrote:
> 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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2008-06-09 16:48:56 | Re: Unable to create function which takes no arguments |
Previous Message | Michael Eshom | 2008-06-09 16:05:52 | Unable to create function which takes no arguments |