Re: Getting rows in a very specific order

Gordon-

without disclosing company proprietary specifics can you provide a pared down schema of the affected
tables and their column names
e.g.
Table1
{
column1 int primary key;
};

Table2
{
int column2;
int column1 references table1(column1)
}

thanks
Martin
_____________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.

> From: gordon(dot)mcvey(at)ntlworld(dot)com
> Subject: [GENERAL] Getting rows in a very specific order
> Date: Mon, 8 Sep 2008 09:29:44 -0700
> To: pgsql-general(at)postgresql(dot)org
>
> I'm considering using an array of ints column in a table which lists a
> row's ancestry. For example, if item 97 is contained within itme 68
> and that item is contained with in 31 and that item is contained
> within item 1 then the value of the hierachy column would be
> {1,31,68,97}, the numbers refer to the primary keys of the rows.
>
> If I use the value of the hierarchy column in a query I can get all
> the rows that a given row is an descendant of. (SELECT * FROM items
> WHERE itm_id IN (1,31,68,97), for example. However, I need the rows
> to be in the correct order, ie the root node first, child second,
> grandchild third etc. I'm guessing the order can be set with an ORDER
> BY, but I've only ever used ORDER BY to order by ascending or
> descending order of a single column. Is there a way to retrieve the
> rows explicitly in the order they are listed in the hierarchy array?
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

_________________________________________________________________
Get more out of the Web. Learn 10 hidden secrets of Windows Live.
http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008