Re: Allowing SYSDATE to Work

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 11/17/06 16:31, Alvaro Herrera wrote:
> Matt Miller wrote:
>> I'd like SYSDATE to work syntactically and semantically the same as
>> CURRENT_TIMESTAMP (or CURRENT_TIME, or whatever). I can create a
>> function called "sysdate" that does the trick, but then it seems I have
>> to reference the function as "sysdate ()," but I want to be able to get
>> away with just "sysdate." It seems that CURRENT_TIMESTAMP and their
>> friends are magic functions that can be referenced without an explicit
>> empty argument list.
>
> current_time and the like are hardcoded in the grammar. You'd have to
> do the same for sysdate. It's not hard, but then I'd question the
> hassle of having to patch all the Postgres installations you're going to
> want to run your code on.

Or is he asking that this feature be added to PG?

- --
Ron Johnson, Jr.
Jefferson LA USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFFXkvcS9HxQb37XmcRAtwHAJ9+GBgAQHI9FoUhjGPmMgImb2cNfQCcC3zZ
2jk+k6ObhXKOZf+HV4j/OY8=
=5bRZ
-----END PGP SIGNATURE-----