X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4DEF9D1B447 for ; Fri, 30 Jan 2004 12:13:02 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 94755-05 for ; Fri, 30 Jan 2004 08:13:04 -0400 (AST) Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by svr1.postgresql.org (Postfix) with SMTP id 7179AD1D249 for ; Fri, 30 Jan 2004 08:12:59 -0400 (AST) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Fri Jan 30 13:12:59 2004 +0100 Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id NAA02764 for ; Fri, 30 Jan 2004 13:12:59 +0100 (MET) From: Christoph Haller Message-Id: <200401301212.NAA11553@rodos> Subject: Empty String Comparison Standard compliant? To: pgsql-sql@postgresql.org Date: Fri, 30 Jan 2004 13:12:58 MET X-Mailer: Elm [revision: 212.4] X-Virus-Scanned: by amavisd-new at postgresql.org X-Amavis-Alert: BAD HEADER Non-encoded 8-bit data (char 9C hex) in message header 'Received' Received: \234by rodos.fzk.de... ^ X-Archive-Number: 200401/284 X-Sequence-Number: 16677 Just a short question (PostgreSQL 7.3.4 on hppa-hp-hpux10.20, compiled by GCC 2.8.1) SELECT ('' > 'GDMF') ; SELECT ('GDMF' > ''); ?column? ---------- f (1 row) ?column? ---------- t (1 row) Are these results standard compliant? Looks at least pretty reasonable to me. It's just because I have a DBMS here, where the results are vice versa. TIA. Regards, Christoph