From: | Eric Aponte <eaponte(at)usb(dot)ve> |
---|---|
To: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Re: Funciones y PHP |
Date: | 2004-11-12 13:32:55 |
Message-ID: | 4194BB87.3040605@usb.ve |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Ok, Gracias, ¡¡ya funciona!!
Alvaro Herrera escribió:
>On Thu, Nov 11, 2004 at 03:57:07PM -0400, Eric Aponte wrote:
>
>
>>La funcion es la siguiente
>>
>>CREATE OR REPLACE FUNCTION "public"."cont_asig" (integer) RETURNS
>>integer AS'
>>begin
>> return (SELECT count(h_sol_en) FROM jzxx where h_sol_tecnico = $1
>>and h_sol_en = ''t'');
>>end;
>>'LANGUAGE 'plpgsql' ;
>>
>>y necesito invocarla desde PHP y obtener el resultado entero que me devuelve
>>
>>
>
>$result = pg_query("select cont_asig($param)");
>if (!$result)
> error("no funciona");
>else
> $var = pg_fetch($result);
>
>O algo por ahi ...
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | fernando villarroel | 2004-11-12 15:01:13 | Re: Palm - PostgreSQL |
Previous Message | Oswaldo Hernández | 2004-11-12 09:51:58 | Re: Palm - PostgreSQL |