Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id CE71B63450D for ; Thu, 5 Mar 2009 15:02: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 66039-06 for ; Thu, 5 Mar 2009 15:02:27 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp-OUT05A.alice.it (smtp-OUT05A.alice.it [85.33.3.5]) by mail.postgresql.org (Postfix) with ESMTP id 218446344AC for ; Thu, 5 Mar 2009 15:02:26 -0400 (AST) Received: from FBCMMO03.fbc.local ([192.168.68.197]) by smtp-OUT05A.alice.it with Microsoft SMTPSVC(6.0.3790.3959); Thu, 5 Mar 2009 19:57:52 +0100 Received: from FBCMCL01B02.fbc.local ([192.168.69.83]) by FBCMMO03.fbc.local with Microsoft SMTPSVC(6.0.3790.1830); Thu, 5 Mar 2009 20:02:29 +0100 Received: from kerberos.webthatworks.it ([82.50.65.145]) by FBCMCL01B02.fbc.local with Microsoft SMTPSVC(6.0.3790.3959); Thu, 5 Mar 2009 20:02:23 +0100 Received: from dawn.webthatworks.it (dawn.webthatworks.it [192.168.1.12]) by kerberos.webthatworks.it (Postfix) with ESMTP id 47CDCE6A96; Thu, 5 Mar 2009 20:02:22 +0100 (CET) Received: from dawn.webthatworks.it (localhost [127.0.0.1]) by dawn.webthatworks.it (Postfix) with ESMTP id E93873DA93; Thu, 5 Mar 2009 20:02:21 +0100 (CET) Date: Thu, 5 Mar 2009 20:02:21 +0100 From: Ivan Sergio Borgonovo To: Jhonny Velasquez c. , Subject: Re: Message-ID: <20090305200221.2e64b8a5@dawn.webthatworks.it> In-Reply-To: References: Organization: http://www.webthatworks.it X-Mailer: Claws Mail 3.7.0 (GTK+ 2.14.7; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 05 Mar 2009 19:02:23.0422 (UTC) FILETIME=[EABDADE0:01C99DC4] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/7 X-Sequence-Number: 32250 On Thu, 5 Mar 2009 11:48:17 -0400 Jhonny Velasquez c. wrote: > $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"); Please don't cross post and this is supposed to be an English list (am I right?). Most of the people here will see your post as noise here. -- Ivan Sergio Borgonovo http://www.webthatworks.it