Re: [SQL] Set Returning Function problem

2004-12-06 Thread Tom Lane
Alvaro Nunes Melo <[EMAIL PROTECTED]> 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 exac

[SQL] Set Returning Function problem

2004-12-06 Thread Alvaro Nunes Melo
Hi, 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. I'm posting an example below: test=> CREATE TABLE foo (cod SERIAL, bar TEXT); NOTICE: CREAT