Since when does "." sort as "nothing at all" This select
select distinct u.user_name from subscriber_user u, subscription s, subscription_template t where u.id = s.subscriber_entity_id and s.template_id = t.id and t.application_id = (select id from application where short_name ='books') order by u.user_name \p\g over this table def.(for user_name) \d subscriber_user Table "public.subscriber_user" +-----------------------+---------+---------------+ | Column | Type | Modifiers | +-----------------------+---------+---------------+ | id | bigint | not null | | last_name | text | | | first_name | text | | | user_name | text | | | email_address | text | | | force_password_change | boolean | default false | | title | text | | +-----------------------+---------+---------------+ Indexes: "subscriber_user_pkey" PRIMARY KEY, btree (id) "idx__subscriber_users__lower_email_address" UNIQUE, btree (lower(email_address)) "idx__subscriber_users__lower_user_name" UNIQUE, btree (lower(user_name)) Foreign-key constraints: "subscriber_user_id_fkey" FOREIGN KEY (id) REFERENCES subscriber(id) is producing this sorted??? output | adrianoha...@hotmail.com | | adx...@show.org.tw | | aeche...@mac.com | | a.eck...@gmx.de | | aelef...@unina.it | | aeo...@hotmail.com | | a.fisched...@t-online.de | | aflores3...@gmail.com | | afr...@advancedneurosurgeons.com | | agave...@comcast.net | | agelsin...@amirsys.com | | agis1...@yahoo.gr | using this client Welcome to psql 8.3.7, the PostgreSQL interactive terminal. and this server show server_version; +----------------+ | server_version | +----------------+ | 8.3.7 | +----------------+ (1 row) nsm=# show server_encoding +-----------------+ | server_encoding | +-----------------+ | UTF8 | +-----------------+ (1 row) -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql