[GENERAL] plpgsql parameters

2006-02-02 Thread FERREIRA, William (VALTECH)
Hi, i have a recursive function building a xml file, from differents table. the xml is stored in memory and then flush on disk. the xml text is used in each recursive calls and i would like to know if in plpqsql parameters are passed by reference, or if there is a key word for passing parameter

Re: [GENERAL] execution plan : Oracle vs PostgreSQL

2006-01-31 Thread FERREIRA, William (VALTECH)
26..0.034 rows=1 loops=1) Index Cond: ((doc_id = $0) AND (ele_id = $1) AND (evolution <= 0) AND (child_id = $2)) Filter: (child_class = $3) Total runtime: 0.483 ms -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] la part

[GENERAL] execution plan : Oracle vs PostgreSQL

2006-01-24 Thread FERREIRA, William (VALTECH)
hi, i have a database storing XML documents. The main table contains the nodes of the document, the other tables contain data for each node (depending on the node's type : ELE, Text, PI, ...) My test document has 115000 nodes. the export of the document(extracting all informations from database

Re: [GENERAL] create plperlu langage fails

2006-01-20 Thread FERREIRA, William (VALTECH)
yes ! i found my problem i added libperl.so (from perl 5.5.7) in LD_LIBRARY_PATH and now it works thanks Will -Message d'origine- De : Michael Fuhr [mailto:[EMAIL PROTECTED] Envoyé : jeudi 19 janvier 2006 18:30 À : FERREIRA, William (VALTECH) Cc : pgsql-general@postgresq

Re: [GENERAL] create plperlu langage fails

2006-01-20 Thread FERREIRA, William (VALTECH)
? i'm working on sun-solaris 2.8 regards -Message d'origine- De : Michael Fuhr [mailto:[EMAIL PROTECTED] Envoyé : jeudi 19 janvier 2006 18:30 À : FERREIRA, William (VALTECH) Cc : pgsql-general@postgresql.org Objet : Re: [GENERAL] create plperlu langage fails On Thu, Jan 19, 200

[GENERAL] create plperlu langage fails

2006-01-19 Thread FERREIRA, William (VALTECH)
hi, i get an exception while trying to create plperlu langage : CREATE OR REPLACE FUNCTION plperl_call_handler() RETURNS language_handler AS '/home/adocv3/postgresql-8.1.2/src/pl/plperl/libplperl.so', 'plperl_call_handler' LANGUAGE 'c' VOLATILE; CREATE LANGUAGE 'plperlu' HANDLER