Re: Unary Operators

From: Andreas Ulbrich <andreas(dot)ulbrich(at)matheversum(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Unary Operators
Date: 2013-09-19 16:14:04
Message-ID: 523B22CC.3070100@matheversum.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 18.09.2013 02:17, David Johnston wrote:
> Andreas Ulbrich wrote
>> create operator ^- (leftarg = float, procedure = reciproce);
>> works too, but
>> create operator / (leftarg = float, procedure = reciproce);
>> not.
> Do you mean the "^" operator or the "^-" operator? Rowan claims that "^"
> does not in fact work here...
>
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/Unary-Operators-tp5770983p5771360.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
I'd like to take the /-Operator as the inverse element of an element
relating to multiplication analogous the '-'-Operator for the inverse
relating to addition.
As a compromise, because the left unary / not work, I took '^-' for "to
the power of minus (one)".

It sounds logical, that native operators (4.1.6, Table 4-2) could be not
redefined with other number of arguments (% doesn't work to as left
unary...). But than a miss some documentation hints what are native
operators.

Thanks

Andreas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paul Ramsey 2013-09-19 17:51:10 Re: Upgrading from postgreSQL 9.1.6 to 9.3
Previous Message fburgess 2013-09-19 15:34:18 Upgrading from postgreSQL 9.1.6 to 9.3