Skip site navigation (1) Skip section navigation (2)

Re: Fwd: Filter by Selection on Grid

From: "Dave Page" <dpage(at)postgresql(dot)org>
To: "Robins Tharakan" <tharakan(at)gmail(dot)com>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Fwd: Filter by Selection on Grid
Date: 2008-02-06 11:41:24
Message-ID: 937d27e10802060341n57298e0cgc58f1f142a588c2e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
On Feb 6, 2008 11:02 AM, Robins Tharakan <tharakan(at)gmail(dot)com> wrote:
> > ... snip ...
> Sure ! Points that I'll take into account from now on.
>
>
> > One other thing I noticed that should be fixed in a new patch - if you
>  > sort ascending on a column, and then sort descending, it will add
> > both. It should remove the ascending and replace it with the
>  > descending sort.
>
> True... and one more thing that I was working on (when I responded to
> Guillaume the other day) was that if a person does an 'exclude by selection'
> on a field with a value = 10, we simply put a [WHERE] value <> 10 filter...
> however I think this is incomplete.
>
> instead of
> WHERE value <> 10
>
> we should rather put
>
> WHERE (value <> 10 OR value IS NULL)
> Or
>  WHERE (value IS DISTINCT FROM 10)
>
> This is because as per the UI, the user does not want value 10, but he still
> would want a NULL value in the records.

Yes, thats a good point. I look forward to seeing the patch ;-)

cheers, Dave.

In response to

Responses

pgadmin-hackers by date

Next:From: Robins TharakanDate: 2008-02-06 17:42:26
Subject: Re: Fwd: Filter by Selection on Grid
Previous:From: Robins TharakanDate: 2008-02-06 11:02:51
Subject: Re: Fwd: Filter by Selection on Grid

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group