Re: Bug #869: varchar 's comparision

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: trainee12(at)yeah(dot)net, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #869: varchar 's comparision
Date: 2003-01-10 04:45:52
Message-ID: 27853.1042173952@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)org writes:
> M_ID VARCHAR(10) M_DESC VARCHAR(10)
> -----------------------------------------------------------
> ABC HELLO

> UPDATE MYTABLE SET M_DESC='GOOD' WHERE M_ID='ABC ' AND M_DESC='HELLO '

> UPDATE 0 RECORDS

My guess is that the stored values do not have trailing spaces.
Trailing spaces are significant data in varchar fields.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Om Computer & Software S.R.L. 2003-01-10 10:11:44 PostgreSQL
Previous Message Stephan Szabo 2003-01-10 04:34:08 Re: Bug #869: varchar 's comparision