Re: troubles with postgresql

On Sun, Feb 23, 2003 at 09:22:44AM +0100, erwan ancel wrote:
> Hi,
> There are 2 things that disturb me in postgresql:
> - apparently, there is no unsigned number type. why ??? This is very useful,
> especially for serials.

Since serial go upto 64 bits, I don't think signed/unsigned will make a
difference.

> - when we get a record containing a fixed sized string rows, we always get a
> string that is filled with spaces at the end to match max size. Again, why ?
> There is no need for these spaces, and I guess those spaces are sent through
> the network, which is not optimal...

You probably defined them char(n). varchar(n) has no padding. text has no
limit in size. Choose the appropriate type for your purposes.

Hope this helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Support bacteria! They're the only culture some people have.