Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E588E63313B; Sat, 7 Mar 2009 13:42:29 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 79487-09; Sat, 7 Mar 2009 13:42:28 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from milkno.com (pfeiffer02.nmmn.net [217.114.78.33]) by mail.postgresql.org (Postfix) with ESMTP id 060EA632685; Sat, 7 Mar 2009 13:42:27 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by milkno.com (Postfix) with ESMTP id 4242115CC0BC; Sat, 7 Mar 2009 18:42:17 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at milkno.com Received: from milkno.com ([127.0.0.1]) by localhost (localhost [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id aOc8KoZAZtnc; Sat, 7 Mar 2009 18:42:16 +0100 (CET) Received: from duke-mac.local (p54ABB89B.dip0.t-ipconnect.de [84.171.184.155]) by milkno.com (Postfix) with ESMTPA id ADDED15CC0C0; Sat, 7 Mar 2009 18:42:15 +0100 (CET) Message-ID: <49B2B1FF.40803@netzmeister-st-pauli.de> Date: Sat, 07 Mar 2009 18:42:23 +0100 From: Andreas Wenk User-Agent: Thunderbird 2.0.0.19 (Macintosh/20081209) MIME-Version: 1.0 To: "Jhonny Velasquez c." CC: pgsql-sql@postgresql.org, pgsql-php@postgresql.org Subject: Re: References: In-Reply-To: Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=NORMAL_HTTP_TO_IP=0.001 X-Spam-Level: X-Archive-Number: 200903/7 X-Sequence-Number: 3997 Jhonny Velasquez c. schrieb: > hola a todos Hi, this is the english mailinglist ... ther's also an spanish mailinglist I guess ;-) > estoy programando en php > tengo el siguiente esquema de BD > > BDACADEMICA > personas(idpersona, nombres, paterno) > > BDSIAP > PersonasDatosActualizables(idpersona, direccion, telefono) > > > son dos bases de datos, de las cuales mediante una sola consulta quiero > unir los datos de la misma persona, creo que se puede hacer con dblink, > no se si hay otra forma mejor. > > $result=pg_query( $linkacademica,"SELECT personas.nombres, > personas.paterno, s.direccion, s.telefono, FROM personas INNER JOIN > dblink('dbname=bdsiap port=5432 host=localhost user=usuario > password=clave,'SELECT idpersona, direccion, telefono FROM > personasdatosactualizables') AS s(idpersona character(15), > direccion character varying(50), telefono character varying(25)) ON > personas.idpersona = s.idpersona"); > Kick away the "komma" (,) befor FROM $result=pg_query( $linkacademica,"SELECT personas.nombres, > personas.paterno, s.direccion, s.telefono FROM personas INNER JOIN Cheers Andy > usando db link me da el siguiente error, supongo que es por las > comillas, he intentado con comillas dobles y simples pero nada, tambien > he intentado usar variables. > > *Warning*: pg_query() [function.pg-query > ]: Query failed: ERROR: > error de sintaxis en o cerca de «FROM» at character 69 in > */var/www/finanzas/prueba.php* on line *16* > ** > ** > espero su ayuda > > saludos > > jhonvels > > ------------------------------------------------------------------------ > check out the rest of the Windows Live™. More than mail–Windows Live™ > goes way beyond your inbox. More than messages > -- ---------------------------------- Netzmeister St.Pauli St.Pauli - Hamburg - Germany Andreas Wenk Lutterothstr 82 20255 Hamburg Tel.: +49 (0) 40 319 43 54 http://www.netzmeister-st-pauli.de mailto:a.wenk@netzmeister-st-pauli.de