Re: BUG #8633: Assigning to a variable named "current_time" gives wrong output

From: bricklen <bricklen(at)gmail(dot)com>
To: michael(dot)lancaster(at)exa-networks(dot)co(dot)uk
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8633: Assigning to a variable named "current_time" gives wrong output
Date: 2013-11-27 16:42:48
Message-ID: CAGrpgQ_6aBgPDXTR3G8KN6tsOuonBdvyXR3UEmB6GFYDqQOm0g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Nov 27, 2013 at 7:49 AM, <michael(dot)lancaster(at)exa-networks(dot)co(dot)uk>wrote:

>
> Reading the value from a variable named 'current_time' that has a value
> assigned to it then assigns the value of the function 'current_time' rather
> than reading the value that was previously assigned.
>

I don't think this is a bug, "current_time" is a reserved word. See
http://www.postgresql.org/docs/current/static/sql-keywords-appendix.html

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Johnston 2013-11-27 16:53:25 Re: BUG #8633: Assigning to a variable named "current_time" gives wrong output
Previous Message Alvaro Herrera 2013-11-27 16:42:27 Re: BUG #8434: Why does dead lock occur many times ?