Re: [HACKERS] money or dollar type - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] money or dollar type
Date
Msg-id 199805131551.LAA15895@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] money or dollar type  ("Jose' Soares Da Silva" <sferac@bo.nettuno.it>)
List pgsql-hackers
>
> create table prova ( my_varchar varchar );
> CREATE
> insert into prova values ('12');
> INSERT 528521 1
> insert into prova values ('a12');
> INSERT 528522 1
> select * from prova where my_varchar = '12';
> my_varchar
> ----------
>         12
> (1 row)
>
> select * from prova;
> my_varchar
> ----------
> 12
> a12
> (2 rows)
>

OK, I can reproduce this now.  I would love to know why it is happening.
Seems very strange to me.


--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] One problem with Postgres...\
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] mmap and MAP_ANON