Postgres Pro
Downloads
Home   >   mailing lists

weird situation, BUG or I'm not doing it right - Mailing list pgsql-sql

From Jiaqing Wang
Subject weird situation, BUG or I'm not doing it right
Date
Msg-id KCEJKHPEBJGGCDBEMMNKIEGCCBAA.jjw72@swbell.net
Whole thread Raw
Responses Re: weird situation, BUG or I'm not doing it right  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Mark Stosberg
Date:
Subject: Re: Separating data sets in a table
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: weird situation, BUG or I'm not doing it right