Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4FDE865013E for ; Thu, 7 Aug 2008 14:16:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 18907-03 for ; Thu, 7 Aug 2008 14:16:14 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.230]) by postgresql.org (Postfix) with ESMTP id 448A1650138 for ; Thu, 7 Aug 2008 14:16:14 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so802856rvf.43 for ; Thu, 07 Aug 2008 10:16:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=QC+BCkxcTrtm6bEor9ESGMA5Z0WSbZ92h3g+jnCFM+k=; b=P+qCtjoerexvtyJ9Fj0tNyN4obC4MunNlvz/PtewrTeW+t6UOzHOFM1sAOiy63SSv+ mo5M+iwOnYz0gjs1+Eo54tlhdN6rXR2NPGpntpClB9+h9N1p4fTIxk/wkMoAQUOSjHnN rgA0IYDRespTf/C2axoAJYYUINXZJP9AGMrmw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=kN0SuIhBYyGsmW8OS+lPFmo6pUmIG8X4SrF+GO/+2eHfHKW4VrHHogOOIfYRmhch/L smFKGS9BIvZjFLWZsUy/1tOO/4SzqHbCQoMbnZBtMK+id0t35HmqUUAxKawsB7vKq6t+ 9yu4y1Qk6iQLASJtVI7c+mM6JA7P6sUJDq7Wo= Received: by 10.141.161.6 with SMTP id n6mr822202rvo.201.1218129372902; Thu, 07 Aug 2008 10:16:12 -0700 (PDT) Received: by 10.141.52.7 with HTTP; Thu, 7 Aug 2008 10:16:12 -0700 (PDT) Message-ID: Date: Thu, 7 Aug 2008 12:16:12 -0500 From: "David Calle" To: pgsql-php@postgresql.org Subject: Procedimientos con parametros MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_24093_4385497.1218129372894" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200808/2 X-Sequence-Number: 3886 ------=_Part_24093_4385497.1218129372894 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hola amigos... necesito una peque=F1a ayuda tengo el siguiente procedimento en postgres: CREATE OR REPLACE FUNCTION consulta_parametros(IN float8, IN float8, OUT out_propietario "varchar", OUT out_tipo "varchar") AS $BODY$ DECLARE fdistancia float(8); ggeometria geometry; BEGIN SELECT DISTANCE(the_geom,SETSRID(makepoint($1,$2), 24877)), the_geom INTO fdistancia, ggeometria FROM recorrido WHERE estado =3D 'V'; --out_distancia =3D fdistancia; SELECT propietario, tipo INTO out_propietario, out_tipo FROM unidades a, recorrido WHERE recorrido.the_geom =3D ggeometria; END; $BODY$ LANGUAGE 'plpgsql' VOLATILE; ALTER FUNCTION consulta_parametros(IN float8, IN float8, OUT out_propietari= o "varchar", OUT out_tipo "varchar") OWNER TO postgres; desde php cuando lo ejecuto no puedo filtrar el resultado x las columnas... pues solo de devuelve el resultado como una sola cadena concatenada... $sql=3D"select consulta_parametros('$var1','$var2')"; $resultado=3Dpg_exec($conn,$sql); $row =3D pg_fetch_row($resultado, 0); echo $row[0]; espero me puedan ayudar.. saludos..! ------=_Part_24093_4385497.1218129372894 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Hola amigos...
necesito una peque=F1a ayuda tengo el si= guiente procedimento en postgres:

CREATE OR REPLACE FUNCTION consult= a_parametros(IN float8, IN float8, OUT out_propietario "varchar",= OUT out_tipo "varchar") AS
$BODY$
DECLARE
    fdistancia    float(= 8);
    ggeometria    geometry;
BEGIN    SELECT DISTANCE(the_geom,SETSRID(makepoint($1,$2), 248= 77)), the_geom
    INTO fdistancia,  ggeometria
&= nbsp;   FROM recorrido
    WHERE estado =3D 'V';
   
=     --out_distancia =3D fdistancia;

   = ; SELECT     propietario, tipo
    INTO&nb= sp;   out_propietario, out_tipo
    FROM &= nbsp;  unidades a, recorrido
    WHERE   r= ecorrido.the_geom =3D ggeometria;

END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE;
ALTER = FUNCTION consulta_parametros(IN float8, IN float8, OUT out_propietario &quo= t;varchar", OUT out_tipo "varchar") OWNER TO postgres;


desde php cuando lo ejecuto no puedo filtrar el resultado x las col= umnas... pues solo de devuelve el resultado como una sola cadena concatenad= a...

$sql=3D"select consulta_parametros('$var1','$v= ar2')";
$resultado=3Dpg_exec($conn,$sql);
$row =3D pg_fetch_row($resultado, 0);<= br>echo $row[0];

espero me puedan ayudar.. saludos..!


------=_Part_24093_4385497.1218129372894--