Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

w2ksp4.exe, WwwxxXdbf, procmail "FROM_MAILER" patch, Use of assignment to $[ is deprecated at /usr/local/sbin/apxs line 86. , wwwxxx vim, mysql closing table and opening table, 800c5000, setgid operation not permitted, pciehp: acpi_pciehprm on IBM, WWWXXX.DBF



#1: select returning resuts in wrong order

Posted on 2006-08-21 17:15:25 by gsexton

I'm using PostgreSQL 8.0.8 with a database created using the UNICODE
encoding. The calendar table has a constraint

ALTER TABLE calendar ADD CONSTRAINT uq_calendr_name UNIQUE (name)

when I run this query:

select name from calendar order by name;

the results come back in the order shown below. I'm really not
understanding this. Why are the entries with periods or asterisks not
sorting to the top?

Akimel A-al Middle School
Altadena Middle School
Aprende Middle School
Brisas Elementary School
Centennial Middle School
Cerritos Elementary School
Cielo Elementary School
Colina Elementary School
.District Office Meeting/Event
Calendar Esperanza Elementary School
Estrella Elementary School
INT - CIE B-8 Lab
INT - CIE Library Lab
INT - KMS Computer Lab 103
INT - KMS Computer Lab EAST
INT - KMS Computer Lab NORTH
Kyrene Middle School
Lagos Elementary School
Lomas Elementary School
Manitas Elementary School
Mariposa Elementary School
.Middle School A/B Schedule
Milenio Elementary School
Mirada Elementary School
Monte Vista Elementary School
Ninos Elementary School
Norte Elementary School
* Official Kyrene School District Calendar 2005-2007
Paloma Elementary School
Pueblo Middle School
Sierra Elementary School
Sureno Elementary School
_Technology Services
Use of Facilities - Cielo
Waggoner Elementary School

George Sexton
MH Software, Inc. - Home of Connect Daily Web Calendar

Report this message