Postgresql doesn't understand the unary plus

From: Martijn van Oosterhout <martijn(at)ecomtel(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgresql doesn't understand the unary plus
Date: 2000-10-29 03:37:31
Message-ID: 20001029143731.A15313@rum.ecomtel.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I definitly consider this a bug but other people may disagree with me. What
I want to know is if it's excluded for any particular reason.

=> select -1;
?column?
--------
-1
=> select +1;
ERROR: Unable to identify a left operator '+' for type 'int4'
You may need to add parentheses or an explicit cast

--
Martijn van Oosterhout

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-10-29 03:53:24 Re: Postgresql doesn't understand the unary plus
Previous Message William H. Geiger III 2000-10-29 00:20:14 Conversion MySql -> PostgresSQL