Larry White <ljw1001(at)gmail(dot)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