Re: now() vs current_user

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: Ottó Havasvölgyi <havasvolgyi(dot)otto(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: now() vs current_user
Date: 2007-09-05 20:44:03
Message-ID: a55915760709051344h41503b98j4f5c2105e9ee765a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/5/07, Ottó Havasvölgyi <havasvolgyi(dot)otto(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-09-05 20:53:42 Re: psql hanging
Previous Message Michael Glaesemann 2007-09-05 20:43:02 Re: now() vs current_user