[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=?

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

[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] SQL Question

005 15:42 À : GIROIRE, Nicolas (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&

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 wher

[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 to SQL. 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

Flight & Ground Information Services - Development     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] plper

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 Clem

Re: [GENERAL] plperl doesn't release memory

as in perl ?    -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,

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 us

[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 put

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

& Ground Information Services - 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 (CO

[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

Re: [GENERAL] Convert Cursor to array

mars 2005 15:01 À : 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. > > Th

[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 this