Re: Why does this not work?

From: "Marin Dimitrov" <marin(dot)dimitrov(at)sirma(dot)bg>
To: "Johann Zuschlag" <zuschlag(at)online(dot)de>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why does this not work?
Date: 2002-04-11 18:39:08
Message-ID: 001b01c1e188$2a5463a0$9b0e32d4@sirma.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


----- Original Message -----
From: "Johann Zuschlag"

>
> Is there a solution for such a problem?
> Let's assume you can't be sure whether you get
> the appropriate length in an insert.
>

what about changing the column from varchar to text?

size shouldn't be an issue and your trigger will be able to cut the content
to the desired length

hth,

Marin

----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-04-11 18:45:06 Re: Why does this not work?
Previous Message Oleg Bartunov 2002-04-11 18:35:06 Re: Critical performance problems on large databases