casting character varying to integer - order by numeric sort

Поиск
Список
Период
Сортировка
От Bryce W Nesbitt
Тема casting character varying to integer - order by numeric sort
Дата
Msg-id 4356EC5D.4080706@obviously.com
обсуждение исходный текст
Ответы Re: casting character varying to integer - order by numeric
Re: casting character varying to integer - order by numeric sort
Список pgsql-sql
How can I force a character field to sort as a numeric field?
I've got something like this:

Postgres=> SELECT username,last_name                 FROM eg_member ORDER BY username;
----------+-----------0120     | Foley1        | Sullivan10       | Guest11       | User
(5 rows)

(I can't change the field type).  I tried: SELECT username,last_name FROM eg_member ORDER BY username::integer;

But postgres 7 rejects this with "ERROR:  cannot cast type character 
varying to integer".  Is there a way to force numeric sort order?  I 
tried a variety of functions, such as to_char() and convert() without 
any luck.  Thanks for your insight!



В списке pgsql-sql по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: NULL in IN clause
Следующее
От: Terry Fielder
Дата:
Сообщение: Re: casting character varying to integer - order by numeric