Re: Inconsistency: varchar is equivalent to varchar(255) and also not equivalent?

From: Boszormenyi Zoltan <zb(at)cybertec(dot)at>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Inconsistency: varchar is equivalent to varchar(255) and also not equivalent?
Date: 2011-10-03 18:32:00
Message-ID: 4E89FFA0.2060001@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2011-10-03 19:17 keltezéssel, Scott Ribe írta:
> On Oct 3, 2011, at 10:12 AM, Boszormenyi Zoltan wrote:
>
>> But I would like to know why isn't the type conversion from unlimited varchar
>> to varchar(255) invoked in the pl/pgsql function?
> What if t1 || t2 is longer than 255? You need to explicitly specify.

Yes, but then explicit casting would be needed everywhere
and it's not the case. My question is more like: why the
record -> record type conversion doesn't try to match
individual elements of the two record types?

--
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de
http://www.postgresql.at/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Boszormenyi Zoltan 2011-10-03 19:35:29 Re: Inconsistency: varchar is equivalent to varchar(255) and also not equivalent?
Previous Message Alban Hertroys 2011-10-03 18:28:57 Re: Inconsistency: varchar is equivalent to varchar(255) and also not equivalent?