X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A6A5B3A3ACB for ; Tue, 9 Nov 2004 14:36:18 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 35831-06 for ; Tue, 9 Nov 2004 14:36:05 +0000 (GMT) Received: from hotmail.com (bay14-f23.bay14.hotmail.com [64.4.49.23]) by svr1.postgresql.org (Postfix) with ESMTP id 3EC663A3C82 for ; Tue, 9 Nov 2004 14:36:08 +0000 (GMT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 9 Nov 2004 06:36:05 -0800 Received: from 200.110.28.50 by by14fd.bay14.hotmail.msn.com with HTTP; Tue, 09 Nov 2004 14:35:16 GMT X-Originating-IP: [200.110.28.50] X-Originating-Email: [mikkal56@hotmail.com] X-Sender: mikkal56@hotmail.com From: "miguel lam" To: tgl@sss.pgh.pa.us, homoelle@ll.mit.edu Cc: pgsql-interfaces@postgresql.org Subject: another newbie libpq question... Date: Tue, 09 Nov 2004 14:35:16 +0000 Mime-Version: 1.0 Content-Type: text/html; charset=iso-8859-1 Message-ID: X-OriginalArrivalTime: 09 Nov 2004 14:36:05.0186 (UTC) FILETIME=[71889A20:01C4C669] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.4 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS, HTML_20_30, HTML_MESSAGE, MIME_HTML_ONLY X-Spam-Level: * X-Archive-Number: 200411/14 X-Sequence-Number: 5140

Hi, well mi problem is that im trying to pass a string with the select but I don't know if postgres has a function for format the query like this

select * from table1 where cod = '%' and cod2 = '%';

and then format the % simbol, because I dont want to concatenate in C all the string because is hard to do it use th epointers and all the stuff, if somebody know how to format the query , please somebody help me !



MSN Amor Busca tu ½ naranja