using string functions on plpgsql

From: "Marcelo Edgardo Paniagua Lizarraga" <mpaniagua18(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: using string functions on plpgsql
Date: 2008-04-16 21:50:09
Message-ID: 2ba670e30804161450q68312d25l3e36a98034badbe9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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!!!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2008-04-17 00:08:26 Re: using string functions on plpgsql
Previous Message Mina R Waheeb 2008-04-16 18:34:43 SQL/XML Multi table join question