Re: now() vs current_user - Mailing list pgsql-general

From Rodrigo De León
Subject Re: now() vs current_user
Date
Msg-id a55915760709051344h41503b98j4f5c2105e9ee765a@mail.gmail.com
Whole thread Raw
In response to now() vs current_user  ("Ottó Havasvölgyi" <havasvolgyi.otto@gmail.com>)
List pgsql-general
On 9/5/07, Ottó Havasvölgyi <havasvolgyi.otto@gmail.com> wrote:
> What is the cause that "now()" works but "now" does not and
> "current_user" works but "current_user()" does not.

From http://www.postgresql.org/docs/8.2/static/functions-info.html :

"Note:  current_user, session_user, and user have special syntactic
status in SQL: they must be called without trailing parentheses."

See:
http://www.google.com/search?q=sql+current_user

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: now() vs current_user
Next
From: "Scott Marlowe"
Date:
Subject: Re: psql hanging