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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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