X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E09F353595 for ; Sun, 27 Mar 2005 16:58:10 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 45342-09 for ; Sun, 27 Mar 2005 15:58:05 +0000 (GMT) Received: from metux.de (seven.metux.de [193.16.1.1]) by svr1.postgresql.org (Postfix) with ESMTP id A156D5355D for ; Sun, 27 Mar 2005 16:58:03 +0100 (BST) Received: (from weigelt@localhost) by metux.de (8.12.10/8.12.10) id j2RFw7s6025223 for pgsql-sql@postgresql.org; Sun, 27 Mar 2005 17:58:07 +0200 Date: Sun, 27 Mar 2005 17:58:07 +0200 From: Enrico Weigelt To: pgsql-sql Subject: (non)zero function Message-ID: <20050327155807.GB16122@nibiru.borg.metux.de> Reply-To: weigelt@metux.de Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/357 X-Sequence-Number: 20836 Hi folks, is there an function returning true if the argument is null or zero (just to make some queries more concise). Of course its trivial to implement as SQL function, but if postgresql already provides such a function, I would prefer using it. cu -- --------------------------------------------------------------------- Enrico Weigelt == metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: contact@metux.de cellphone: +49 174 7066481 --------------------------------------------------------------------- -- DSL ab 0 Euro. -- statische IP -- UUCP -- Hosting -- Webshops -- ---------------------------------------------------------------------