RE: Threaded Records in SQL: Advice Needed

Поиск
Список
Период
Сортировка
От Ingram, Bryan
Тема RE: Threaded Records in SQL: Advice Needed
Дата
Msg-id 9B7D4396307CD311809A00500415EB405FE1E9@BKMAIL
обсуждение исходный текст
Ответ на Threaded Records in SQL: Advice Needed  ("Ingram, Bryan" <BIngram@sixtyfootspider.com>)
Ответы Re: Threaded Records in SQL: Advice Needed  (mig@utdt.edu)
Re: Threaded Records in SQL: Advice Needed  ("tjk@tksoft.com" <tjk@tksoft.com>)
Список pgsql-sql
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 ....