Re: Why does this not work? (finally) - Mailing list pgsql-general

From Johann Zuschlag
Subject Re: Why does this not work? (finally)
Date
Msg-id E16vkAy-0006oR-00@mrvdomng2.kundenserver.de
Whole thread Raw
In response to Re: Why does this not work?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Thu, 11 Apr 2002 14:45:06 -0400, Tom Lane wrote:

>> Is there a solution for such a problem?
>
>Don't use varchar(n) --- use text.  You can still enforce the length
>limit you want inside the trigger, if you really want a length limit
>at all.

Thanks to all, for your help. It seems it is not possible.
Ok, I go for the text solution. The only trouble is, I have
to debug my application to see what nonsense it is
trying to do. But postgresql/psqlodbc is good help doing
that.

IIRC there is no speed difference between varchar and text?

regards

Johann Zuschlag
zuschlag@online.de



pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Why does this not work?
Next
From: Gunther Schadow
Date:
Subject: Re: Critical performance problems on large databases