Re: Set Returning Function problem - Mailing list pgsql-sql

From Tom Lane
Subject Re: Set Returning Function problem
Date
Msg-id 5105.1102358820@sss.pgh.pa.us
Whole thread Raw
In response to Set Returning Function problem  (Alvaro Nunes Melo <al_nunes@atua.com.br>)
List pgsql-sql
Alvaro Nunes Melo <al_nunes@atua.com.br> writes:
> I noticed what i think is a weird behaviour with SRFs. When I use them
> in a SELECT clause, and the SRF returns no rows, the query returns no
> rows too, when I think it should return an a null column.

Why would you think that?  The behavior is exactly right as-is.
        regards, tom lane


pgsql-sql by date:

Previous
From: Alvaro Nunes Melo
Date:
Subject: Set Returning Function problem
Next
From: Greg Stark
Date:
Subject: Re: Making dirty reads possible?