diff options
| author | Heikki Linnakangas | 2009-04-23 07:19:09 +0000 |
|---|---|---|
| committer | Heikki Linnakangas | 2009-04-23 07:19:09 +0000 |
| commit | 283939a321bc492045d00c80146d52672cfc5378 (patch) | |
| tree | c88e5f4c1d3716077413c3614daf5fcc66ec0235 /contrib/citext/expected | |
| parent | 8d4f2ecd41312e57422901952cbad234d293060b (diff) | |
varstr_cmp and any comparison function that piggybacks on it can return
any negative or positive number, not just -1 or 1. Fix comment on
varstr_cmp and citext test case accordingly.
As pointed out by Zdenek Kotala, and buildfarm member gothic moth.
Diffstat (limited to 'contrib/citext/expected')
| -rw-r--r-- | contrib/citext/expected/citext.out | 8 | ||||
| -rw-r--r-- | contrib/citext/expected/citext_1.out | 8 |
2 files changed, 8 insertions, 8 deletions
diff --git a/contrib/citext/expected/citext.out b/contrib/citext/expected/citext.out index 4d8f1ac066..c3dfc95803 100644 --- a/contrib/citext/expected/citext.out +++ b/contrib/citext/expected/citext.out @@ -213,10 +213,10 @@ SELECT citext_cmp('AARDVARK'::citext, 'AARDVARK'::citext) AS zero; 0 (1 row) -SELECT citext_cmp('B'::citext, 'a'::citext) AS one; - one ------ - 1 +SELECT citext_cmp('B'::citext, 'a'::citext) > 0 AS true; + true +------ + t (1 row) -- Do some tests using a table and index. diff --git a/contrib/citext/expected/citext_1.out b/contrib/citext/expected/citext_1.out index e9bb6124c8..49a6817aef 100644 --- a/contrib/citext/expected/citext_1.out +++ b/contrib/citext/expected/citext_1.out @@ -213,10 +213,10 @@ SELECT citext_cmp('AARDVARK'::citext, 'AARDVARK'::citext) AS zero; 0 (1 row) -SELECT citext_cmp('B'::citext, 'a'::citext) AS one; - one ------ - 1 +SELECT citext_cmp('B'::citext, 'a'::citext) > 0 AS true; + true +------ + t (1 row) -- Do some tests using a table and index. |