is there any defect when use null column in postgresql?

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

On Mon, Mar 16, 2009 at 11:36 AM, Scott Marlowe <scott.marlowe@gmail.com>wrote:

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

On Sun, Mar 15, 2009 at 9:39 PM, leopay <leopay@gmail.com> wrote:

On Mon, Mar 16, 2009 at 11:36 AM, Scott Marlowe <scott.marlowe@gmail.com>
wrote:

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