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, whole thread or download thread mbox)
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' > '');
(1 row)

(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. 


Regards, Christoph 


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-2017 The PostgreSQL Global Development Group