Re: Precedence of % - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Precedence of %
Date
Msg-id 27481.1117900537@sss.pgh.pa.us
Whole thread Raw
In response to Re: Precedence of %  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: Precedence of %
Re: Precedence of %
List pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> I don't even grasp what unary modulo actually means???

At some point in the dim mists of prehistory, somebody thought it would
be cute to define prefix % as trunc() and postfix % as round().  I'm not
aware of any precedent for that; it was probably mostly an exercise in
testing out the grammar.

Now that I look, it doesn't look like these operators are documented
at all in the SGML docs, so it sure seems that removing them should be
pretty painless.
        regards, tom lane


pgsql-hackers by date:

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