Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] [GENERAL]

Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] [GENERAL]

This is a discussion on Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] [GENERAL] within the pgsql Hackers forums, part of the PostgreSQL category; --> Dann Corbit wrote: > Try this query in Oracle, SQL*Server, DB/2, Informix, etc.: > > connxdatasync=# select 1 where ...

		Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers
Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] [GENERAL]

#1 (permalink)

04-11-2008, 07:20 AM

Kevin Grittner

Posts: n/a

Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] [GENERAL]

Dann Corbit wrote:
> Try this query in Oracle, SQL*Server, DB/2, Informix, etc.:
>
> connxdatasync=# select 1 where cast('a' as varchar(30)) = cast('a ' as
> varchar(30));
> ?column?
> ----------
> (0 rows)

For what it's worth, on Sybase ASE I get:

-----------
1
(1 row affected)

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

« tuning seqscan costs | Re: [GENERAL] 'a' == 'a ' »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 07:58 PM.