[SQL] using string functions on plpgsql

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 a

Re: [SQL] UTF8 Vs Latin9 and valid encoding.

when I type áéíóúñ on screen I see ßØ«·± Why would this be? Thanks again --- Markus Schaber <[EMAIL PROTECTED]> wrote: > Hi, Marcelo, > > Marcelo . wrote: > > > I receive the error msg: > > ERROR: invalid UTF-8 byte sequence detected near > byte > >

[SQL] UTF8 Vs Latin9 and valid encoding.

Hello, I am using postgres 8.1 for windows and have the following dilema. I have 2 databases, one encoded in UTF-8 and one in Latin9. In both DBs I can create the following test table: CREATE TABLE "holaniño" ( nombre varchar(5), "titúlo" varchar(10) ) WITHOUT OIDS; Then in both DBs I can

[SQL] Problem with VACUUM

d I think it looking for a table or an atributte of inherits but we have already droped it. The PostgresSQL version is: 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96 Thanks Marcelo. ---(end of broadcast)--- TIP 1: subscribe and unsubs

[SQL] Delete a FOREIGN KEY

Hi All,   I'm beginner in PostgreSQL! So, how can I delete a FOREIGN KEY in PostgreSQL?   Thanks.   Marcelo Henrique da Silva.

[SQL] How to display a unixtimestamp from a timestamp record?

27;epoch' , timestamp 'acct_timestamp') from tbacct limit 2; it said ERROR: Bad timestamp external representation 'acct_timestamp' how should i represent date_part( 'epoch' , timestamp 'acct_timestamp') to work? Thanks in Advance -- Marcelo Bartsch