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

Using perform in plpgsql throws compile errors

From: mail <mail(at)peneios(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Using perform in plpgsql throws compile errors
Date: 2004-09-24 17:58:35
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Sorry if this is a re-post, but my posts don't seem to get through ...


I am trying to create a really simple pl/pgsql based function to simply
return true or false depending on a query result ...

As I do not need the query result row, I want to use PERFORM to dump the
resulting data ... So, here's my attempt:

CREATE OR REPLACE FUNCTION islicensed(int8, int8) RETURNS bool AS '
    pID ALIAS FOR $1;
    aID ALIAS FOR $2;
    PERFORM SELECT * FROM transactions x INNER JOIN tx_items i ON( =
i.tx_id) where i.archive_id=aID and x.status=\'valid\' and x.person_id=pID;
' LANGUAGE 'plpgsql';

However, even so the creation statement succeeds, any attempt to call
this function throws a compilation error:

ERROR:  syntax error at or near "SELECT" at character 9
CONTEXT:  PL/pgSQL function "islicensed" line 5 at perform

Why this? As I understand the docs, this is how it should work!?!

Any help is highly appreciated.

Oh, PostgreSQL 7.4.1 running on RH Linux ES 3.0 (not from RH rpm, but
compiled from sources) ...



pgsql-novice by date

Next:From: Tom LaneDate: 2004-09-24 18:47:01
Subject: Re: Using perform in plpgsql throws compile errors
Previous:From: Zhenchang XingDate: 2004-09-24 17:34:24
Subject: can connectby() deal with cyclic graph?

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