weird situation, BUG or I'm not doing it right

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: Whole Thread | Raw Message | 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

Responses

Browse pgsql-sql by date

  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