Empty String Comparison Standard compliant? - Mailing list pgsql-sql

From Christoph Haller
Subject Empty String Comparison Standard compliant?
Date
Msg-id 200401301212.NAA11553@rodos
Whole thread Raw
Responses Re: Empty String Comparison Standard compliant?
Re: Empty String Comparison Standard compliant?
List 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 



pgsql-sql by date:

Previous
From: Greg Stark
Date:
Subject: Re: limit 1 and functional indexes: SOLVED
Next
From: Tom Lane
Date:
Subject: Re: Empty String Comparison Standard compliant?