Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 3BC092E0037 for ; Wed, 16 Apr 2008 18:50:13 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 25890-02 for ; Wed, 16 Apr 2008 18:50:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.241]) by developer.postgresql.org (Postfix) with ESMTP id 13EF62E0030 for ; Wed, 16 Apr 2008 18:50:10 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so746504ana.33 for ; Wed, 16 Apr 2008 14:50:10 -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:content-transfer-encoding:content-disposition; bh=aB3ga9QfWoJgdnqc3G4J+dJEXrJHWGZUqzRU9pUz9jI=; b=wusSnzQEqTI0eQsssOxynSxAXC3fuMZFqHTDdrxz9TILfFwepZchmJ4/49h4oVLi9MkvnOjGR74aVLNJTzFLP8SqrFwVR1q/FzqUQT1znzW/ObtoApUePDbJnIfd0WxMSof1x5hfGYB14P49KfPFYOdYpmzZQp90ZbGrlnjd0/s= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=CIHh7CZ65Io5wvT96W23B7tv8w4ZFQ8XX3/zFNDhcGMvJboKA6BtdzrX6RLDlI7i6UUIuTrO73tU5k5i3xDCx7vUSNWVnbDq7XVBhyL5+h5kIk0NDfO/xe5+8Rc7s0i8LX7jzxXNB4LHS8TV/QF9Tc//nptyPq2c80BMl5PR4ig= Received: by 10.100.46.10 with SMTP id t10mr814846ant.156.1208382609953; Wed, 16 Apr 2008 14:50:09 -0700 (PDT) Received: by 10.100.41.18 with HTTP; Wed, 16 Apr 2008 14:50:09 -0700 (PDT) Message-ID: <2ba670e30804161450q68312d25l3e36a98034badbe9@mail.gmail.com> Date: Wed, 16 Apr 2008 14:50:09 -0700 From: "Marcelo Edgardo Paniagua Lizarraga" To: pgsql-sql@postgresql.org Subject: using string functions on plpgsql MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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: 200804/100 X-Sequence-Number: 30639 I'm starting to create my firsts plpgsql functions, and I was wondering how to use the string function 'length' in the code of the fuction. I have tried so far and I get an error. I'm trying this: declare i integer; begin ... i = length(texto) ... where texto is a varchar(200) I pass as a parameter to the function calling. Any help will help. Thanks!!!