X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 0297DB43A5C for ; Thu, 3 Jul 2003 18:54:29 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 19258-10 for ; Thu, 3 Jul 2003 15:54:19 -0300 (ADT) Received: from MAIL.nucleus.com (mail1.nucleus.com [207.34.101.2]) by svr1.postgresql.org (Postfix) with ESMTP id E97D0B43A54 for ; Thu, 3 Jul 2003 15:54:05 -0300 (ADT) Received: from dsl-mtryl-209-5-169-111-cgy.nucleus.com (unverified [209.5.169.111]) by MAIL.nucleus.com (Vircom SMTPRS 2.1.255) with ESMTP id ; Thu, 3 Jul 2003 12:53:58 -0600 From: "Andrew J. Kopciuch" Reply-To: akopciuch@bddf.ca Organization: BDDF Consulting To: "yanping huang" , pgsql-php@postgresql.org Subject: Re: help Date: Thu, 3 Jul 2003 12:51:21 -0600 User-Agent: KMail/1.5 References: <20030702205111.8629ABF741@email.altimate.ca> In-Reply-To: <20030702205111.8629ABF741@email.altimate.ca> X-MailKey: Flyers winning makes BDDF happy MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200307031251.21706.akopciuch@bddf.ca> X-Archive-Number: 200307/17 X-Sequence-Number: 2129 > How can I put a '^' befor a variable of VARCHAR type in a function? > Is this what you are looking for ... the concatentation operator? select '^' || 'sometext'::varchar; If you are asking about doing that in the function call : select myfunction( '^' || var); Andy