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

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Boszormenyi Zoltan <zb(at)cybertec(dot)at>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Inconsistency: varchar is equivalent to varchar(255) and also not equivalent?
Date: 2011-10-03 17:17:07
Message-ID: E2EF5EAD-2EDD-429A-BC73-4E5157DCA9B6@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Boszormenyi Zoltan 2011-10-03 17:31:53 Re: Inconsistency: varchar is equivalent to varchar(255) and also not equivalent?
Previous Message Alan Hodgson 2011-10-03 17:09:20 Re: : PostgreSQL Online Backup