pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christoph Haller <ch@rodos.fzk.de>
To: pgsql-sql@postgresql.org
Subject: Empty String Comparison Standard compliant?
Date: Fri, 30 Jan 2004 13:12:58 MET
Message-ID: <200401301212.NAA11553@rodos> (raw)

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 




view thread (3+ messages)  latest in thread

Message-ID: <200401301212.NAA11553@rodos>
Permalink:  ../200401301212.NAA11553@rodos/
Also on:    postgresql.org/message-id/200401301212.NAA11553@rodos

 · 

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: ch@rodos.fzk.de
  Subject: Re: Empty String Comparison Standard compliant?
  In-Reply-To: <200401301212.NAA11553@rodos>

* 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