Re: troubles with postgresql

Поиск
Список
Период
Сортировка
От Thomas Beutin
Тема Re: troubles with postgresql
Дата
Msg-id 20030223120320.A32633@laokoon.bug.net
обсуждение исходный текст
Ответ на troubles with postgresql  ("erwan ancel" <erwan.ancel@free.fr>)
Ответы Re: troubles with postgresql
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Hubert depesz Lubaczewski
Дата:
Сообщение: different way to create function?
Следующее
От: Ruben
Дата:
Сообщение: Re: How to update rows from a cursor in PostgreSQL