Re: [pgsql-advocacy] Oracle buys Innobase

On 10/19/2005 3:46 PM, Dann Corbit wrote:
> Would you want varchar(30) 'Dann Corbit' to compare equal to bpchar(30)
> 'Dann Corbit'?
>
> I would.

wieck=# select 'Jan'::varchar(20) = 'Jan'::char(20);
?column?
----------
t
(1 row)

wieck=# select 'Jan'::char(20) = 'Jan'::varchar(20);
?column?
----------
t
(1 row)

wieck=# select version();
version
---------------------------------------------------------------------
PostgreSQL 8.0.4 on i386-unknown-freebsd4.9, compiled by GCC 2.95.4
(1 row)

Did I miss anything?

Jan

>
> If both are considered character types by the language, then they must
> compare that way.
>
> Perhaps there are some nuances that I am not aware of. But that is how
> things ought to behave, if I were king of the forest.
>
>> -----Original Message-----
>> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
>> owner(at)postgresql(dot)org] On Behalf Of Terry Fielder
>> Sent: Wednesday, October 19, 2005 12:37 PM
>> To: Marc G. Fournier
>> Cc: Richard_D_Levine(at)raytheon(dot)com; pgsql-general(at)postgresql(dot)org
>> Subject: Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase
>>
>> OK, I am not an expert on the SQL standard, but I thought the
> definition
>> varied by data type e.g. varchar <> bpchar
>>
>> Terry
>>
>> Marc G. Fournier wrote:
>> > On Wed, 19 Oct 2005, Richard_D_Levine(at)raytheon(dot)com wrote:
>> >
>> >> I was referring to trailing blanks, but did not explicitly say it,
>> >> though showed it in the examples. I am pretty sure that the SQL
>> >> standard says that trailing whitespace is insignificant in string
>> >> comparison.
>> >
>> >
>> > Then we are broken too :)
>> >
>> > # select 'a ' = 'a ';
>> > ?column?
>> > ----------
>> > f
>> > (1 row)
>> >
>> > ----
>> > Marc G. Fournier Hub.Org Networking Services
>> (http://www.hub.org)
>> > Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ:
>> 7615664
>> >
>> > ---------------------------(end of
> broadcast)---------------------------
>> > TIP 4: Have you searched our list archives?
>> >
>> > http://archives.postgresql.org
>> >
>>
>> --
>> Terry Fielder
>> terry(at)greatgulfhomes(dot)com
>> Associate Director Software Development and Deployment
>> Great Gulf Homes / Ashton Woods Homes
>> Fax: (416) 441-9085
>>
>> ---------------------------(end of
> broadcast)---------------------------
>> TIP 6: explain analyze is your friend
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #