Re: troubles with postgresql

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.

In response to

Responses

Browse pgsql-general by date

  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?