Re: rows and array

FERREIRA William (COFRAMI) wrote:
> i want do to it in a stored procedure using the pl/pgSQL language.
> i can't use "ORDER by" because the traitment is very specific.
>
> for example, in oracle syntaxe i can create my own type :
>     type recordChild is TABLE OF XDB_CHILD%ROWTYPE
> and next when i declare my variable with this type :
>     children recordChild;
> i can store rows and re-order them like this :
> children(i-j) := children(i-j-1);

Well, I'd look at one of three solutions:
  1. Functional index to order by
  2. Temporary table (read up on EXECUTE and OID caching)
  3. pl/perl/python (which are better suited to this sort of thing)

Probably worth looking into functional indexes - might be what you need.
--
   Richard Huxton
   Archonet Ltd