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 <[email protected]> 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.
pgp622ekhvx9h.pgp
Description: PGP signature
