Problem : array of table%ROWTYPE

[nico31120]

Hi,
I'm searching to deploy a pl/sql module to a pl/pgsql other.
My problem is that I use in pl/sql a bulk that represents an array of which elements are row of a table and I search to do the same thing in postgresql.

I want an array of which element are table%ROWTYPE to allow me to move element in these array.

Is someone as an idea ?

(I hope you understand me!)

best regards.

 

[rycamor]

I probably don't understand. Exactly how do you want to "move element in these array"? What are you trying to accomplish? Are you saying the array is composed of multiple rows from the table, or composed of individual elements from *one* table row?

Maybe if you posted that part of your PL/SQL code we could get an idea what you are trying to do.

 

[nico31120]

In fact I want to order by criteria elements which I pick out from database and the idea is to use an array.
Each elements I want to put in the array is an individual element which is one table row.

So the declaration of the array would be : element table%ROWTYPE []
But it doesn't seem to exist ?