Cast Operator Precedence - Mailing list pgsql-hackers

From David E. Wheeler
Subject Cast Operator Precedence
Date
Msg-id 2982FC68-BED4-421E-91FD-F725CA769755@justatheory.com
Whole thread Raw
Responses Re: Cast Operator Precedence
List pgsql-hackers
Hackers,

I found this surprising:
david=# CREATE DOMAIN STATUS AS INTEGER CHECK ( VALUE IN (1, 2, 3) );
CREATE DOMAIN

david=# select -4::status;
ERROR:  value for domain status violates check constraint "status_check"

david=# select -1::status;?column? 
----------      -1
(1 row)

david=# select (-1)::status;
ERROR:  value for domain status violates check constraint "status_check"

So I guess the precedence of :: is higher than -?

Thanks,

David




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Draft release notes complete
Next
From: Tom Lane
Date:
Subject: Re: Cast Operator Precedence