Re: Bugs: fill value with cursor

Programmazione softsystem.it wrote:
> Hi,
> Excuse my bad english.
> The value of field created using insert into cursor or similar are
> filling with space ( "one" -> "one     "), this is not good and very
> different with another database windows.
> This is a large block for using application windows with database for
> s.o. unix.

What are the datatype of the field? If it is char(X) PostgreSQL will
pad or truncate it so that it is always X characters long. Try using
varchar(X) (where X is maximum length) instead.

/Oskar

--
/-----------------------+---------------------------+------------------\
| SGS Datanätgrupp      | www.sgs.studenthem.gu.se  | Office Hours     |
| Utlandagatan 24       | E-mail: dng@sgs.o.se      |   Mon-Thur 17-19 |
| 412 80  Göteborg      | Phone:  031-7081335       |                  |
\-----------------------+---------------------------+------------------/