Re: I must be blind... - Mailing list pgsql-general

Nigel J. Andrews wrote:
<snip>
>         dirn ALIAS FOR     $4;
>         time ALIAS FOR     $5;
>         status ALIAS FOR   $6;
>     BEGIN
>         -- check against order
>         PERFORM
>             SELECT 1
>                 FROM orders
>                 WHERE
>                     id = ordid
>                     AND
>                     direction = dirn;
>         IF NOT FOUND THEN
</snip>

I don't think you can use PERFORM like that. Try:

<snip>
        dirn ALIAS FOR     $4;
        time ALIAS FOR     $5;
        status ALIAS FOR   $6;
        buf INT;
    BEGIN
        -- check against order
            SELECT 1 INTO buf
                FROM orders
                WHERE
                    id = ordid
                    AND
                    direction = dirn;
        IF NOT FOUND THEN
</snip>

HTH,

Joe