Skip site navigation (1) Skip section navigation (2)

Re: Re: charin(), text_char() should return something else for empty input

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Don Baccus <dhogaza(at)pacifier(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: charin(), text_char() should return something else for empty input
Date: 2001-05-28 19:59:43
Message-ID: 15448.991079983@sss.pgh.pa.us (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-hackers
Don Baccus <dhogaza(at)pacifier(dot)com> writes:
> Mapping '' to ' ' doesn't make a lot of sense to me.  It isn't what
> I'd expect.
> I think the behavior you describe in this note is better.

I'm coming to that conclusion as well.  If you look closely, both
charin() and charout() act that way already; so the second proposal
boils down to making the text <=> char conversion functions act in
accordance with the way that char's I/O conversions already act.
That seems a less drastic change than altering both I/O and conversion
behavior.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: D'Arcy J.M. CainDate: 2001-05-28 21:04:52
Subject: Re: User functions and AIX
Previous:From: Don BaccusDate: 2001-05-28 19:25:09
Subject: Re: Re: charin(), text_char() should return something else for empty input

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group