Re: Quota query with decent performance?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Troels Arvin <troels(at)arvin(dot)dk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Quota query with decent performance?
Date: 2003-11-18 14:36:27
Message-ID: 20031118143627.GA32105@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Nov 18, 2003 at 15:21:43 +0100,
Troels Arvin <troels(at)arvin(dot)dk> 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)

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2003-11-18 14:45:57 Re: Quota query with decent performance?
Previous Message Troels Arvin 2003-11-18 14:21:43 Re: Quota query with decent performance?