Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id A37112E0079 for ; Wed, 16 Apr 2008 21:08:32 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 85339-04 for ; Wed, 16 Apr 2008 21:08:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by developer.postgresql.org (Postfix) with ESMTP id E59612E0071 for ; Wed, 16 Apr 2008 21:08:28 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m3H08QAt005370; Wed, 16 Apr 2008 20:08:26 -0400 (EDT) To: "Marcelo Edgardo Paniagua Lizarraga" cc: pgsql-sql@postgresql.org Subject: Re: using string functions on plpgsql In-reply-to: <2ba670e30804161450q68312d25l3e36a98034badbe9@mail.gmail.com> References: <2ba670e30804161450q68312d25l3e36a98034badbe9@mail.gmail.com> Comments: In-reply-to "Marcelo Edgardo Paniagua Lizarraga" message dated "Wed, 16 Apr 2008 14:50:09 -0700" Date: Wed, 16 Apr 2008 20:08:26 -0400 Message-ID: <5369.1208390906@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/101 X-Sequence-Number: 30640 "Marcelo Edgardo Paniagua Lizarraga" writes: > 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. There's nothing obviously wrong with what you posted, so the problem is somewhere in what you left out. If you want useful help, it's generally advisable to show a complete example of what you did and exactly what error message you got. regards, tom lane