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(at)bumba(dot)net>