Thread: is there any defect when use null column in postgresql?
I wanna if there is any defact when use null column in pg,
e.g. performance issue
e.g. performance issue
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:none that I know of. Any more specific scenarios you're wondering about?
> I wanna if there is any defact when use null column in pg,
> e.g. performance issue
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.