Horton

Re: [HACKERS] lower() broken?

Roland Roberts <roberts@panix.com>

View thread
From: Roland Roberts <roberts@panix.com>
To: hackers@postgreSQL.org
Date: 1999-02-20T04:50:07Z
Lists: pgsql-hackers 
-----BEGIN PGP SIGNED MESSAGE-----

>>>>> "Vince" == Vince Vielhaber <vev@michvhf.com> writes:

    Vince> Oops!  Yeah, I guess lower wouldn't work so well if it was
    Vince> a numeric field.  Anyway, username is a char(8).

It won't be equal to 'joblo', it will be equal to 'joblo   '.  You may
want to consider using varchar(8).

roland
- -- 
		       PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD                  Custom Software Solutions
roberts@panix.com                           101 West 15th St #4NN
rbroberts@acm.org                              New York, NY 10011

-----BEGIN PGP SIGNATURE-----
Version: 2.6.2
Comment: Processed by Mailcrypt 3.4, an Emacs/PGP interface

iQCVAwUBNs4+/eoW38lmvDvNAQHyYwQAm5l6iiHIzHmpZ+9hYUe+FX81TeKLG7Tm
koqbU3zxCVHVRcWID7PH7EjnHhPYga19ctNyE8Y0nVsKpzc9DadACfBdYexUy+Qc
TdS9WiDzFyO0eOg4BrjV67ZWBtTwIxOYng9NSZHlUOgNx9HLggmIH0Tnfl2vyU8H
EAaq/zlq6c8=
=Lizm
-----END PGP SIGNATURE-----