From: | Jiaqing Wang <jjw72(at)swbell(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Cc: | jjw72(at)swbell(dot)net |
Subject: | weird situation, BUG or I'm not doing it right |
Date: | 2002-08-25 05:56:31 |
Message-ID: | KCEJKHPEBJGGCDBEMMNKIEGCCBAA.jjw72@swbell.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello,
I found below situation weird, it seems to me a bug.
backend=> select * from valid_addr;
zip_code | city_name | state_abrev
----------+----------------------+-------------
00601 | ADJUNTAS | PR
00602 | AGUADA | PR
00603 | AGUADILLA | PR
00604 | AGUADILLA | PR
00605 | AGUADILLA | PR
00606 | MARICAO | PR
00610 | ANASCO | PR
00611 | ANGELES | PR
00612 | ARECIBO | PR
00613 | ARECIBO | PR
00614 | ARECIBO | PR
00616 | BAJADERO | PR
00617 | BARCELONETA | PR
00622 | BOQUERON | PR
00623 | CABO ROJO | PR
00624 | PENUELAS | PR
00627 | CAMUY | PR
00631 | CASTANER | PR
00636 | ROSARIO | PR
00637 | SABANA GRANDE | PR
backend=> select * from valid_addr where state_abrev=upper('pr');
zip_code | city_name | state_abrev
----------+-----------+-------------
(0 rows)
while "select * from valid_addr where state_abrev='PR';" produces following
output
zip_code | city_name | state_abrev
----------+-------------------+-------------
00601 | ADJUNTAS | PR
00602 | AGUADA | PR
00603 | AGUADILLA | PR
00604 | AGUADILLA | PR
00605 | AGUADILLA | PR
00606 | MARICAO | PR
00610 | ANASCO | PR
00611 | ANGELES | PR
00612 | ARECIBO | PR
00613 | ARECIBO | PR
00614 | ARECIBO | PR
00616 | BAJADERO | PR
00617 | BARCELONETA | PR
00622 | BOQUERON | PR
00623 | CABO ROJO | PR
00624 | PENUELAS | PR
00627 | CAMUY | PR
00631 | CASTANER | PR
00636 | ROSARIO | PR
00637 | SABANA GRANDE | PR
jjw
8/24/2002
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paesold | 2002-08-25 12:49:21 | Re: weird situation, BUG or I'm not doing it right |
Previous Message | Manuel Sugawara | 2002-08-25 05:20:09 | left join query does not perform well |