Title: RE: [GENERAL] rows and array
i don't want to do the re-ordering on the client side.
i want a stored procedure which extract some rows from a database into an array.
next i have a function for re-ordering the array depending on specific needs
and finally generate a XML file o
Richard Huxton writes:
> FERREIRA William (COFRAMI) wrote:
>> 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/p
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 declar
Title: RE: [GENERAL] rows and array
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%R
FERREIRA William (COFRAMI) wrote:
hi
does postgresql allows to store rows into array ?
i select rows in a table and i would like to sort them depending on my
criteria.
Is this different from
SELECT a,b,c FROM t ORDER BY a ASC, b DESC;
If so, could you specify more details - what language you are
