Re: Problem with too short column - Mailing list pgsql-admin

From scott.marlowe
Subject Re: Problem with too short column
Date
Msg-id Pine.LNX.4.33.0402061421500.6661-100000@css120.ihs.com
Whole thread Raw
In response to Problem with too short column  (Thomas.AUBRY@limagrain.com)
List pgsql-admin
On Wed, 4 Feb 2004 Thomas.AUBRY@limagrain.com wrote:

> Hi,
>
> I actually try to insert varchar which length is higher than 32 in a column
> which type is varchar(32). I can't change the type of the column, and I
> want to trunc the data. I know it's possible ! I have seen this !
>
> Example : "j'aime les saucisses avec du beurre dedans" will be "j'aime les
> saucisses avec du beu". For the moment it produces a SQL Error !
>
> Is it an option in the config files ?

Note that in my previous posting I think I used substring with a 0 start,
it should start at 1:

select substring('abcdefgh',1,4);
SELECT
substring
----
abcd


pgsql-admin by date:

Previous
From: Sam Barnett-Cormack
Date:
Subject: Re: Problem with too short column
Next
From: "scott.marlowe"
Date:
Subject: Re: talking to port 5432