Re: function runs on Windows not on solaris - Mailing list pgsql-general

From Tom Lane
Subject Re: function runs on Windows not on solaris
Date
Msg-id 14297.1092962748@sss.pgh.pa.us
Whole thread Raw
In response to function runs on Windows not on solaris  (suraj mundada <surajmundada@yahoo.com>)
List pgsql-general
suraj mundada <surajmundada@yahoo.com> writes:
>   UPDATE db_license_tab SET account_id=accountId,license_anniversarydate=current_date(),license_status=1 WHERE
license_key=licKey;

> ERROR:  parser: parse error at or near "(" at character 80

I believe CURRENT_DATE is supposed to be called without parentheses.

            regards, tom lane

pgsql-general by date:

Previous
From: Dave Cramer
Date:
Subject: Re: int8, primary key, seq scan
Next
From: Tom Lane
Date:
Subject: Re: libpq: passwords WAS: scripting & psql issues