Skip site navigation (1) Skip section navigation (2)

Empty String Comparison Standard compliant?

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Empty String Comparison Standard compliant?
Date: 2004-01-30 13:12:58
Message-ID: 200401301212.NAA11553@rodos (view raw or flat)
Thread:
Lists: pgsql-sql
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 


Responses

pgsql-sql by date

Next:From: Tom LaneDate: 2004-01-30 15:18:51
Subject: Re: Empty String Comparison Standard compliant?
Previous:From: Greg StarkDate: 2004-01-30 09:56:22
Subject: Re: limit 1 and functional indexes: SOLVED

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group