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@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Terry Fielder
> Sent: Wednesday, October 19, 2005 12:37 PM
> To: Marc G. Fournier
> Cc: Richard_D_Levine@raytheon.com; pgsql-general@postgresql.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@raytheon.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@hub.org Yahoo!: yscrappy ICQ:
> 7615664
> >
> > ---------------------------(end of
broadcast)---------------------------
> > TIP 4: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>
> --
> Terry Fielder
> terry@greatgulfhomes.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