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

Re: String Translation

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: David Wheeler <david(at)kineticode(dot)com>, sfpug(at)postgresql(dot)org
Subject: Re: String Translation
Date: 2003-10-16 17:59:59
Message-ID: 20031016175959.GD86551@perrin.nxad.com (view raw or flat)
Thread:
Lists: sfpug
> David,
> 
> >      active               NUMERIC(1,0)   NOT NULL
> >                                          DEFAULT 1
> >                                          CONSTRAINT ck_sd_tile__active
> >                                            CHECK (active IN (0,1)),
> 
> Why is this field NUMERIC if it only accepts 0 or 1?  NUMERIC takes
> up seven times the storage and memory as INT2 would.

Or for that matter, use BOOL and save another byte as BOOL is only one
byte on disk.  -sc

-- 
Sean Chittenden

In response to

sfpug by date

Next:From: Dror MatalonDate: 2003-10-16 18:01:11
Subject: Re: String Translation
Previous:From: Josh BerkusDate: 2003-10-16 17:54:15
Subject: Re: String Translation

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