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

2009-03-15 Thread Scott Marlowe
On Sun, Mar 15, 2009 at 9:39 PM, leopay  wrote:
>
>
> On Mon, Mar 16, 2009 at 11:36 AM, Scott Marlowe 
> wrote:
>>
>> On Sun, Mar 15, 2009 at 9:00 PM, leopay  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.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


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

2009-03-15 Thread leopay
On Mon, Mar 16, 2009 at 11:36 AM, Scott Marlowe wrote:

> On Sun, Mar 15, 2009 at 9:00 PM, leopay  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?


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

2009-03-15 Thread Scott Marlowe
On Sun, Mar 15, 2009 at 9:00 PM, leopay  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?

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[GENERAL] is there any defect when use null column in postgresql?

2009-03-15 Thread leopay
I wanna if there is any defact when use null column in pg,
e.g. performance issue


[GENERAL] Is there any defect when use null column in postgresql?

2009-03-15 Thread leopay
I wanna if there is any defact when use null column in postgresql,
e.g. performance issue