Re: Function problems redux - Mailing list pgsql-general

From Johnny J\xF8rgensen
Subject Re: Function problems redux
Date
Msg-id 200111051854330109.024DCB75@mail.halfahead.dk
Whole thread Raw
In response to Function problems redux  (tony <tony@animaproductions.com>)
List pgsql-general
there is a missing ; in the line

>INSERT INTO individu (individu_id,nom,prenom,type2) VALUES (ival, nom,
>prenom, art)

...

*********** REPLY SEPARATOR  ***********

On 05-11-2001 at 10:23 tony wrote:

>Hello,
>
>Here is my function. It takes two variables a_artiste(name, forename).
>
>DECLARE
>artiste_id individu.individu_id%TYPE;
>nom ALIAS FOR $1;
>prenom ALIAS FOR $2;
>ival INTEGER := nextval('individu_serial');
>art TEXT := 'artiste';
>curr INTEGER := currval('individu_serial');
>BEGIN
>SELECT INTO artiste_id * FROM individu WHERE to_ascii(nom) ILIKE
>to_ascii(individu.nom) AND to_ascii(prenom) ILIKE
>to_ascii(individu.prenom) AND type ILIKE 'collection' OR type2 ILIKE
>'artiste';
>IF NOT FOUND THEN
>INSERT INTO individu (individu_id,nom,prenom,type2) VALUES (ival, nom,
>prenom, art)
>RETURN curr;
>END IF;
>RETURN artiste_id;
>END;
>
>ERROR:  parser: parse error at or near "return"
>DEBUG:  Last error occured while executing PL/pgSQL function a_artiste
>DEBUG:  line 11 at SQL statement
>
>This works just fine for known artists but my IF NOT FOUND clause is
>seriously broken
>
>HELP =:-D
>
>Cheers
>Tony
>
>
>
>
>--
>RedHat Linux on Sony Vaio C1XD/S
>http://www.animaproductions.com/linux2.html
>Macromedia UltraDev with PostgreSQL
>http://www.animaproductions.com/ultra.html
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html




pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: EXCEPT performace
Next
From: Tom Lane
Date:
Subject: Re: EXCEPT performace