Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #8633: Assigning to a variable named "current_time" gives wrong output - Mailing list pgsql-bugs

From bricklen
Subject Re: BUG #8633: Assigning to a variable named "current_time" gives wrong output
Date
Msg-id CAGrpgQ_6aBgPDXTR3G8KN6tsOuonBdvyXR3UEmB6GFYDqQOm0g@mail.gmail.com
Whole thread Raw
In response to BUG #8633: Assigning to a variable named "current_time" gives wrong output  (michael.lancaster@exa-networks.co.uk)
Responses Re: BUG #8633: Assigning to a variable named "current_time" gives wrong output  (David Johnston <polobo@yahoo.com>)
List pgsql-bugs
Tree view 
On Wed, Nov 27, 2013 at 7:49 AM, <michael.lancaster@exa-networks.co.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

pgsql-bugs by date:

Previous
From: michael.lancaster@exa-networks.co.uk
Date:
Subject: BUG #8633: Assigning to a variable named "current_time" gives wrong output
Next
From: David Johnston
Date:
Subject: Re: BUG #8633: Assigning to a variable named "current_time" gives wrong output