Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group