Re: troubles with postgresql - Mailing list pgsql-general

Hi,

On Sun, Feb 23, 2003 at 09:22:44AM +0100, erwan ancel wrote:
> - apparently, there is no unsigned number type. why ??? This is very useful,
> especially for serials.
AFIAK there no unsigned int, but You can define the MINVALUE  and START(-value)
for the sequence, so this is IMHO not a big problem.

> - 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 ?
I bet You're using char(n) instead of varchar(n)?! char(n) is space padded up
to the length of n chars.

Hope this helps.

-tb
--
Thomas Beutin                             tb@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.