Re: Newbie question: returning rowtypes from a plpgsql function

Larry White <ljw1001@gmail.com> writes:
> I wrote a function that returns a rowtype.  The rowtype is assigned a
> value by a query using SELECT INTO.  The query sometimes will return
> no rows.  When it does, the function's return value is a row with no
> values.

> I would have expected it to return 0 rows, like the query itself.

How exactly would SELECT INTO return 0 rows?  Perhaps the target
variables vanish into a black hole?

            regards, tom lane