sql trees move some element

hi

I have a table:
 id          | integer | not null default
 nextval('public.menu_2_id_seq'::text)
 parent_id   | integer |
 description | text    | not null

how am I able to move some element with id = x before or after
element with id = y ?

--
WBR, sector119