[GENERAL] PL/SQL: function call like $1($2)

2006-10-08 Thread Jean-Gerard Pailloncy
I want to create a function in PL/SQL as CREATE OR REPLACE FUNCTION "f_do" (text, double precision[]) RETURNS double precision AS ' DECLARE f text := $1; p double precision[] := $2; res double precision; BEGIN SELECT f(p) into res; RETURN res; END;' LANGUAGE "plpgsql" STABLE

Re: [GENERAL] Certificate, login & php question ? krb / sso

2006-09-11 Thread Jean-Gerard Pailloncy
Le 11 sept. 06 à 05:57, Michael Fuhr a écrit :On Sun, Sep 10, 2006 at 09:39:59PM -0600, Michael Fuhr wrote: On Mon, Sep 11, 2006 at 02:32:26AM +0200, Jean-Gerard Pailloncy wrote: 1) Is it possible to use the SSL authentification done by apache with  PostgreSQL ? I'm not aware of a way for A

[GENERAL] Certificate, login & php question ?

2006-09-10 Thread Jean-Gerard Pailloncy
Hi,I have setup an apache server with SSL.I create a CA, serker.key, server.crt.I create a user.key and user.cert.Now the apache server accept only the correct certificate for login on a given directory.I have a PHP script that query the database using the HTTP login/password as PostgreSQL user/pas