FERREIRA William (COFRAMI) wrote:
ok, i think that i will try to use pl/perl or pl/python
but i don't know which one is better for my problem
Whichever you know better is the best solution.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
T
Title: RE: [GENERAL] Convert Cursor to array
ok, i think that i will try to use pl/perl or pl/python
but i don't know which one is better for my problem
maybe you can help me.
thanks
-Message d'origine-
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]De la part de Rich
Title: RE: [GENERAL] Convert Cursor to array
well my example was incomplete :
at the begin :
chapter_id | evolution | index
1 | 0 | 1
2 | 0 | 2
3 | 0 | 3
4 | 1 | 2
5 | 1 | 4
by using the
On Mon, 2005-03-14 at 10:44 +0100, FERREIRA William (COFRAMI) wrote:
> so we choice to use a different solution which consist on using the
> index of a chapter and its evolution.
> if we have this data :
> chapter_id | evolution | index
>1 | 0 | 1
>2 | 0 |
Title: RE: [GENERAL] Convert Cursor to array
hi
i'm a friend of nicolas and i'm working with him on this project
so this is the problem :
we are working on an application allowing to manage documentation in xml format.
At the the first level, there is the root, and at the next l
GIROIRE Nicolas (COFRAMI) wrote:
my sort algorithm is a very particular solution.
In fact, I put record in array to allow me to sort record. I sort them by
using one column of my table but the column indx can have duplicate value
and it's volontary.
I still can't see why you can't sort by that colu
Title: RE: [GENERAL] Convert Cursor to array
my sort algorithm is a very particular solution.
In fact, I put record in array to allow me to sort record. I sort them by using one column of my table but the column indx can have duplicate value and it's volontary.
here is the order algo
GIROIRE Nicolas (COFRAMI) wrote:
Hi,
In a procedure, I put data of Cursor in a two-dimensional array. This allows
me to sort rows.
The problem is this method is too slow.
In fact, I translate a pl/sql procedure to a plpgsql.
Under Oracle, we use bulk and I search to use equivalent of this under
pos
Title: Convert Cursor to array
Hi,
In a procedure, I put data of Cursor in a two-dimensional array. This allows me to sort rows.
The problem is this method is too slow.
In fact, I translate a pl/sql procedure to a plpgsql.
Under Oracle, we use bulk and I search to use equivalent of this
