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 | PR00602 | AGUADA |
PR00603 | AGUADILLA | PR00604 | AGUADILLA | PR00605 | AGUADILLA | PR00606 |
MARICAO | PR00610 | ANASCO | PR00611 | ANGELES | PR00612 | ARECIBO
| PR00613 | ARECIBO | PR00614 | ARECIBO | PR00616 | BAJADERO |
PR00617 | BARCELONETA | PR00622 | BOQUERON | PR00623 | CABO ROJO | PR00624 |
PENUELAS | PR00627 | CAMUY | PR00631 | CASTANER | PR00636 | ROSARIO
| PR00637 | 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 | PR00602 | AGUADA | PR00603
|AGUADILLA | PR00604 | AGUADILLA | PR00605 | AGUADILLA | PR00606 | MARICAO |
PR00610 | ANASCO | PR00611 | ANGELES | PR00612 | ARECIBO | PR00613 | ARECIBO
| PR00614 | ARECIBO | PR00616 | BAJADERO | PR00617 | BARCELONETA | PR00622
|BOQUERON | PR00623 | CABO ROJO | PR00624 | PENUELAS | PR00627 | CAMUY |
PR00631 | CASTANER | PR00636 | ROSARIO | PR00637 | SABANA GRANDE | PR
jjw
8/24/2002