[GENERAL] returning in postgresql request

Hi, I try to deploy an Application with Oracle Database to a solution with postgresql. the Oracle system exists and we use a request which return an int in a variable nb by returning nb_lock into nb UPDATE xdb_ancestors_lock SET nb_lock=nb_lock+1 WHERE doc_id=?

[GENERAL] XA connection problem

Hi, I'm working on carrying out application on Oracle database to PostgreSQL. The server is weblogic. For Oracle we use XA connection but there isn't in PostgreSQL so I try to use XA emulate Connection taht allows weblogic. But I don't succeed to use it correctly. The connection seems correct,

Re: [GENERAL] triggers using the correct schema ..

Hi, you can use SET search_path TO :"defaultSchema"; with replacing "defaultSchema" by the name of schema you want as default. Then all create are automatically done in this schema. Nicolas -Message d'origine-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]De la part de Paul

Re: [GENERAL] SQL Question

For the first request (How can i select only the newest record for each ProdId ?), you can do : select * from test.tableProd u where u.LastUpdate = (select max(t.LastUpdate) from test.tableProd t where

Re: [GENERAL] SQL Question

(COFRAMI) Cc : Alex; pgsql-general@postgresql.org Objet : Re: [GENERAL] SQL Question GIROIRE, Nicolas (COFRAMI) wrote: For the first request (How can i select only the newest record for each ProdId ?), you can do : select * from test.tableProd u where u.LastUpdate = (select max(t.LastUpdate

[GENERAL] File execution

Title: RE: [GENERAL] Convert Cursor to array Hi, Is anyone can say me if it's possible to execute a sql file by the console of pgadmin ? I want to do a system similar toSQL. For example i have a file with the creation of table and i want to execute like this "@createTable" . Thanks.

Re: [GENERAL] plperl doesn't release memory

Phone : +33 (0)5 67 19 98 74 Mailto:[EMAIL PROTECTED] -Message d'origine- De : Sean Davis [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 31 mars 2005 13:15 À : GIROIRE Nicolas (COFRAMI) Objet : Re: [GENERAL] plperl doesn't release memory On Mar 31, 2005, at 1:38 AM, GIROIRE Nicolas

Re: [GENERAL] Help with order by into a RECORD

Title: FW: [GENERAL] Help with order by into a RECORD Yes, you can use ORDER BY on the table whiwh have an or several index. Index allows to save time during execution of request. -Message d'origine-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]De la part de Shaun

Re: [GENERAL] plperl doesn't release memory

? -Message d'origine-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]De la part de GIROIRE Nicolas (COFRAMI)Envoyé: jeudi 31 mars 2005 08:38À: Postgresql-General listObjet: Re: [GENERAL] plperl doesn't release memory Hi, I work with William. In fact, we have already done

Re: [GENERAL] plperl doesn't release memory

Title: RE: [GENERAL] plperl doesn't release memory Hi, I work with William. In fact, we have already done the procedure in pl/pgsql but it is too slow and we use array which are native in perl. The procedure is recursive, and use request on postgreSQL. According to the evolution of memory

Re: [GENERAL] sort array optimisation in pl/perl

- Development Phone : +33 (0)5 67 19 98 74 Mailto:[EMAIL PROTECTED] -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]De la part de Ragnar Hafstað Envoyé : jeudi 24 mars 2005 21:53 À : GIROIRE Nicolas (COFRAMI) Cc : 'pgsql-general@postgresql.org' Objet : Re

[GENERAL] pl/perl problem of memory

Title: pl/perl problem of memory Hi, I load data in a varible of type text, and i arrive to out of memory message. I want to know if it exists a function which allows to empty a variable and the place uses in memory without destroy it (because I use the variable again). In fact, now i

[GENERAL] sort array optimisation in pl/perl

Title: sort array optimisation in pl/perl Hi, I create an array which is result of query on postgresql database and then I want to sort rows in a particular way (impossible by query on database). My solution consists to put a rows (indice m+1) in a temporary other and then move all element

[GENERAL] Convert Cursor to array

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

Re: [GENERAL] Convert Cursor to array

: GIROIRE Nicolas (COFRAMI) Cc : 'pgsql-general@postgresql.org' Objet : Re: [GENERAL] Convert Cursor to array 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