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

Newbie in functions

From: Eduardo_Cadena(at)praxair(dot)com
To: pgsql-novice(at)postgresql(dot)org
Subject: Newbie in functions
Date: 2002-04-17 14:52:43
Message-ID: OF971F569C.5DDD7BD2-ON86256B9E.0051AFC5@praxair.com (view raw or flat)
Thread:
Lists: pgsql-novice
I´m trying to create a function to obtain the possition of a substring, but
i don't kown if is correct
can anyone can  help me to do this?

test=# CREATE FUNCTION pos1 (int4) RETURNS int4 AS '
test'# UPDATE tabla1
test'#   SET posicion1 = position('pm' in SELECT string1 FROM tabla1 WHERE
id = $1)
test'#   WHERE id = $1;
test'# SELECT posicion1 FROM tabla1 WHERE id = $1;
test'# 'LANGUAGE sql;
ERROR:  parser: parse error at or near "pm"
test=#


thanks for your help


Responses

pgsql-novice by date

Next:From: Josh BerkusDate: 2002-04-17 16:13:35
Subject: Re: cannot restore db
Previous:From: pg sqlDate: 2002-04-17 14:21:45
Subject: Re: [DOCS] Upgrading - How? - Administrator's Guide ??

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