Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Materialised Path Heirarchy

Re: Materialised Path Heirarchy

From: stu <smcgouga_at_nospam.co.uk>
Date: Thu, 27 Mar 2003 11:32:41 -0000
Message-ID: <b5unk5$10o$1$8302bc10@news.demon.co.uk>

"Murat Okay" <murat_okay at yahoo dot com> wrote in message news:#42WTMF9CHA.2316_at_TK2MSFTNGP10.phx.gbl...
> Stu,
> As far as I know, SQL Server doesn't support this. You must do it
> "manually".

I take it you mean SQL does not provide numeric sorting on a text field. This is what i thought and why I came up with the idea to have a fixed length representation for each level.

Cheers
Stu Received on Thu Mar 27 2003 - 05:32:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US