Re: [SQL] Ordering by field using lower()

2001-10-13 Thread Tom Lane
speedboy <[EMAIL PROTECTED]> writes: > Hi, please view the output from some queries below. My question is, why is > the ordering apparently wrong when using the lower() function? You're getting a textual sort, not a numeric sort. > The field "pid" is of type int2 and there is no need to use lowe

[SQL] Ordering by field using lower()

2001-10-13 Thread speedboy
Hi, please view the output from some queries below. My question is, why is the ordering apparently wrong when using the lower() function? The field "pid" is of type int2 and there is no need to use lower(), but I will need to put a test clause in php if my order type is pid so I do not use lower(