> links=# select * from foo where a < 'Test0'::bpchar;
> a
> ---
> (0 rows)
> links=#
> Are you saying the second test should have returned true under C locale?
Yes. You are not really in C locale, or at least your postmaster isn't.
This looks like ISO sorting rules to me --- perhaps
"Vadim I. Passynkov" <[EMAIL PROTECTED]> writes:
> test=# select rpad ( host ( '127.0.0.1' ), 15 );
>rpad
> ---
> 127.0.0.1
> (1 row)
This is fixed in current sources (7.1beta4).
regards, tom lane
Hi All,
This is not working
test=# select rpad ( host ( '127.0.0.1' ), 15 );
rpad
---
127.0.0.1
(1 row)
This working OK
test=# select rpad ( host ( '127.0.0.1' ) || '', 15 );
rpad
-
127.0.0.1
(1 row)
Other examples
test=# select now() where
Tom Lane wrote:
> [EMAIL PROTECTED] writes:
>
>> When overwriting an lo with a larger lo, the old data is not overwritten. This was
>supposed to be fixed in 6.5, but it happens in 7.0.3
>
> Please try your test case in 7.1beta3 or later. The large-object
> support has been rather completely r
