Postgres Pro
Downloads
Home   >   mailing lists

Postgresql doesn't understand the unary plus - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Postgresql doesn't understand the unary plus
Date
Msg-id 20001029143731.A15313@rum.ecomtel.com.au
Whole thread Raw
Responses Re: Postgresql doesn't understand the unary plus  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "William H. Geiger III"
Date:
Subject: Conversion MySql -> PostgresSQL
Next
From: Tom Lane
Date:
Subject: Re: Postgresql doesn't understand the unary plus