Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A9CFC475AAC for ; Sat, 24 Aug 2002 23:45:47 -0400 (EDT) Received: from mta5.rcsntx.swbell.net (mta5.rcsntx.swbell.net [151.164.30.29]) by postgresql.org (Postfix) with ESMTP id 45655475A1E for ; Sat, 24 Aug 2002 23:45:47 -0400 (EDT) Received: from wwtsyyjjw ([216.61.64.77]) by mta5.rcsntx.swbell.net (iPlanet Messaging Server 5.1 (built May 7 2001)) with SMTP id <0H1D00JIGRSG9X@mta5.rcsntx.swbell.net> for pgsql-sql@postgresql.org; Sat, 24 Aug 2002 22:45:52 -0500 (CDT) Date: Sat, 24 Aug 2002 22:56:31 -0700 From: Jiaqing Wang Subject: weird situation, BUG or I'm not doing it right To: pgsql-sql@postgresql.org Cc: jjw72@swbell.net Message-id: MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7BIT Importance: Normal X-Priority: 3 (Normal) X-MSMail-priority: Normal X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/335 X-Sequence-Number: 9181 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