Skip site navigation (1) Skip section navigation (2)

Re: Is current_user a function ?

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Masaru Sugawara <rk73(at)sea(dot)plala(dot)or(dot)jp>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Is current_user a function ?
Date: 2002-11-28 16:34:49
Message-ID: 1038501288.54963.16.camel@jester (view raw or flat)
Thread:
Lists: pgsql-hackers
Force the system to use it as a function.

select "current_user"();

On Thu, 2002-11-28 at 11:31, Masaru Sugawara wrote:
> Hi,
> 
> As for some current_*** functions, "select current_user;" seems to
> work, but  "select current_user();" doesn't . Though current_user is
> defined as one of functions, why does such an error occur ?
> 
> renew=# select current_user();
> ERROR:   parser: parse error at or near "(" at character 20
> 
> 
> Regards,
> Masaru Sugawara
> 
> 
> renew=# \df
>                                                               List of functions
>    Result data type  |   Schema   |         Name          | Argument data types                                                 
> ---------------------+------------+-----------------------+-----------
>  ...
>  name                | pg_catalog | current_database      | 
>  name                | pg_catalog | current_schema        | 
>  name[]              | pg_catalog | current_schemas       | boolean
>  text                | pg_catalog | current_setting       | text
>  name                | pg_catalog | current_user          | 
>  ...
> 
> 
> renew=# select current_user();
> ERROR:   parser: parse error at or near "(" at character 20
> 
> renew=# select current_database();
>  current_database 
> ------------------
>  renew
> (1 row)
> 
> renew=# select current_schema();
>  current_schema 
> ----------------
>  public
> (1 row)
> 
> renew=# select current_schema(true);
>    current_schemas   
> ---------------------
>  {pg_catalog,postgres,public}
> (1 row)
> 
> renew=# select current_schema(false);
>    current_schemas   
> ---------------------
>  {postgres,public}
> (1 row)
> 
> renew=# select current_setting('search_path');
>  current_setting 
> -----------------
>  $user,public
> (1 row)
> 
> 
> 
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
-- 
Rod Taylor <rbt(at)rbt(dot)ca>


In response to

Responses

pgsql-hackers by date

Next:From: Evgen PotemkinDate: 2002-11-28 17:27:53
Subject: Hierarchical queries a la Oracle. for ver 7.3rc1
Previous:From: Masaru SugawaraDate: 2002-11-28 16:31:47
Subject: Is current_user a function ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group