X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 89B6AD1BB4F for ; Tue, 18 Nov 2003 14:38:11 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 43727-05 for ; Tue, 18 Nov 2003 10:37:44 -0400 (AST) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 3A88ED1C9E9 for ; Tue, 18 Nov 2003 10:37:40 -0400 (AST) Received: (qmail 32172 invoked by uid 500); 18 Nov 2003 14:36:27 -0000 Date: Tue, 18 Nov 2003 08:36:27 -0600 From: Bruno Wolff III To: Troels Arvin Cc: pgsql-sql@postgresql.org Subject: Re: Quota query with decent performance? Message-ID: <20031118143627.GA32105@wolff.to> Mail-Followup-To: Troels Arvin , pgsql-sql@postgresql.org References: <20031118125642.GC30809@wolff.to> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/214 X-Sequence-Number: 16029 On Tue, Nov 18, 2003 at 15:21:43 +0100, Troels Arvin wrote: > On Tue, 18 Nov 2003 06:56:42 -0600, Bruno Wolff III wrote: > > [...] > > where not isfalse (age <= > [...] > > Strange. I can't find the ISFALSE in neither PostgreSQL or standard SQL > documentation. How can that be? I didn't remember the exact syntax and found the isfalse function by guessing. The standard syntax is expression is false instead of isfalse(expression), though the function does work (in 7.4 at least). area=> select isfalse(null); isfalse --------- f (1 row)