RE: Threaded Records in SQL: Advice Needed

Поиск
Список
Период
Сортировка
Искать
От
Ingram, Bryan
Тема
RE: Threaded Records in SQL: Advice Needed
Дата
Msg-id
9B7D4396307CD311809A00500415EB405FE1E9@BKMAIL
Список
Дерево обсуждения
RE: Threaded Records in SQL: Advice Needed "Ingram, Bryan" <BIngram@sixtyfootspider.com>
RE: Threaded Records in SQL: Advice Needed Michael McCarthy <michael@tcsi.com>
Thanks for the ideas on the functions, that'll work nicely.

The only other problem I see in actually implementing this, is that the id
column i.e. /25/10/2/ will not be ordered correctly because it relies on
ascii values.  You get alphabetic orderings, rather than numerical.

Such as:

1
10
11
12
14
2
20
25
3
4
5

instead of

1
2
3
4
5
10
11
12
14
20
25

Any ideas how to get around this?  I'm working on the problem right now, but
haven't found anything yet.

Bryan



В списке pgsql-sql по дате отправления
От: Antonio W. Lagnada
Дата:
Сообщение: DBD::ODBC for Linux
От: Bahena, Dario (CAP, ITS, MX)
Дата:
Сообщение: SQL92 specification ....
FAQ