Re: is there any defect when use null column in postgresql?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: leopay <leopay(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: is there any defect when use null column in postgresql?
Date: 2009-03-16 03:51:40
Message-ID: dcc563d10903152051t11002035y9ad199bb34799a24@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Mar 15, 2009 at 9:39 PM, leopay <leopay(at)gmail(dot)com> wrote:
>
>
> On Mon, Mar 16, 2009 at 11:36 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
> wrote:
>>
>> On Sun, Mar 15, 2009 at 9:00 PM, leopay <leopay(at)gmail(dot)com> wrote:
>> > I wanna if there is any defact when use null column in pg,
>> > e.g. performance issue
>>
>> none that I know of.  Any more specific scenarios you're wondering about?
>
> when do the query, the column contain none value could use the index?

Older versions, no, modern versions yes. When that changed, I don't
know, as I'm running only 8.3 anymore.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jack W 2009-03-16 04:59:03 pg_ctl issue
Previous Message leopay 2009-03-16 03:39:01 Re: is there any defect when use null column in postgresql?