Re: Infix Function?

On Sun, Jun 26, 2005 at 03:42:25PM -0500, Peter Fein wrote:
> Hi-
>
> I've defined an XOR function as:
>
>
> CREATE OR REPLACE FUNCTION xor(bool, bool)
> RETURNS bool AS
> 'SELECT ($1 OR $2) AND NOT ($1 AND $2);'
> LANGUAGE 'sql' IMMUTABLE STRICT;
>
> Is there anyway to create an infix version of this? I'd really like be
> able to write (where a..d are some boolean conditions):

Judging by:

http://www.postgresql.org/docs/7.4/interactive/sql-createoperator.html

operators can't be normal text strings...

Hope this helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.