>
> 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)