pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Jiaqing Wang <jjw72@swbell.net>
To: pgsql-sql@postgresql.org
Cc: jjw72@swbell.net
Subject: weird situation, BUG or I'm not doing it right
Date: Sat, 24 Aug 2002 22:56:31 -0700
Message-ID: <KCEJKHPEBJGGCDBEMMNKIEGCCBAA.jjw72@swbell.net> (raw)

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




view thread (5+ messages)  latest in thread

Message-ID: <KCEJKHPEBJGGCDBEMMNKIEGCCBAA.jjw72@swbell.net>
Permalink:  ../KCEJKHPEBJGGCDBEMMNKIEGCCBAA.jjw72@swbell.net/
Also on:    postgresql.org/message-id/KCEJKHPEBJGGCDBEMMNKIEGCCBAA.jjw72@swbell.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: jjw72@swbell.net
  Subject: Re: weird situation, BUG or I'm not doing it right
  In-Reply-To: <KCEJKHPEBJGGCDBEMMNKIEGCCBAA.jjw72@swbell.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox