Re: Precedence of % - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Precedence of %
Date
Msg-id 42A1CC12.2040707@familyhealth.com.au
Whole thread Raw
In response to Re: Precedence of %  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Precedence of %
List pgsql-hackers
> round() and trunc() also have the virtue that they already have versions
> for type numeric.  If we keep the operators then we'll be right back
> with the complaint that was lodged the other day about exponentiation,
> namely unexpected precision loss for numeric inputs:
> 
> regression=# select 12345678901234567890.55 %;
>        ?column?
> ----------------------
>  1.23456789012346e+19
> (1 row)

I don't even grasp what unary modulo actually means???

Chris


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Precedence of %
Next
From: Tom Lane
Date:
Subject: Re: Quick-and-dirty compression for WAL backup blocks