Re: plpgsql and rowtypes

Tom Lane wrote:

>
>Not sure why plpgsql insists on the explicit marker that a rowtype is
>meant, but it does.
>

    Oh, spiffy.  This works now, thanks.

    One other thing that seems odd to me follows, the relevant
documentation is section 23.6.2.4.  Again, I could be misunderstanding
the semantics, but it seems intuitively wrong that this construct should
behave as I'm seeing:

test=# CREATE FUNCTION ifelsetest(int) RETURNS bool AS '
test'#  BEGIN
test'#   IF $1 = 4 THEN RETURN true;
test'#   ELSIF $1 = 7 THEN RETURN true;
test'#   ELSE return false;
test'#   END IF;
test'#  END; ' language 'plpgsql';
CREATE
test=# select ifelsetest(2);
 ifelsetest
------------
 f
(1 row)

test=# select ifelsetest(4);
 ifelsetest
------------
 t
(1 row)

test=# select ifelsetest(7);
 ifelsetest
------------
 f
(1 row)

    Cheers,
        dj trombley
        <dtrom@bumba.net>