Re: Identifying no-op length coercions - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Identifying no-op length coercions
Date
Msg-id BANLkTikuy3f1vYtb807mPDU3nkmvHbNxsg@mail.gmail.com
Whole thread Raw
In response to Re: Identifying no-op length coercions  (Jim Nasby <jim@nasby.net>)
List pgsql-hackers
On Fri, Jun 3, 2011 at 11:43 AM, Jim Nasby <jim@nasby.net> wrote:
> On Jun 3, 2011, at 10:11 AM, Alexey Klyukin wrote:
>>> Is your interest in cheap varchar(N)->varchar(N+M) conversions specifically, or
>>> in some broader application of this facility?
>>
>> Exactly varchar conversions.
>
> Why limit it to varchar? Shouldn't we be able to do this for any varlena? The only challenge I see is numeric; we'd
needto ensure that both size and precision are not decreasing.
 

More than that: you should also be able to make it work for things
like xml -> text.

Indeed, I believe Noah has plans to do just that.

Which, quite frankly, will be awesome.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: About bug #6049
Next
From: Robert Haas
Date:
Subject: Re: Change 'pg_ctl: no server running' Exit Status to 3