From: | Thomas Beutin <tyrone(at)laokoon(dot)IN-Berlin(dot)DE> |
---|---|
To: | erwan ancel <erwan(dot)ancel(at)free(dot)fr> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: troubles with postgresql |
Date: | 2003-02-23 11:03:20 |
Message-ID: | 20030223120320.A32633@laokoon.bug.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)laokoon(dot)IN-Berlin(dot)DE
Beam me up, Scotty. There is no intelligent live down in Redmond.
From | Date | Subject | |
---|---|---|---|
Next Message | Ruben | 2003-02-23 12:27:31 | Re: How to update rows from a cursor in PostgreSQL |
Previous Message | Hubert depesz Lubaczewski | 2003-02-23 10:47:26 | different way to create function? |