Re: [pgsql-advocacy] Oracle buys Innobase

Would you want varchar(30) 'Dann Corbit' to compare equal to bpchar(30)
'Dann Corbit'?

I would.

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