Re: [HACKERS] Null row vs. row of nulls in plpgsql

2009-01-07 Thread Tom Lane
Bruce Momjian writes: > I assume this is a TODO, right? Yah. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Null row vs. row of nulls in plpgsql

2009-01-07 Thread Bruce Momjian
I assume this is a TODO, right? --- Tom Lane wrote: > I looked a bit at the bug report here: > http://archives.postgresql.org/pgsql-bugs/2008-09/msg00164.php > > ISTM that the fundamental problem is that plpgsql doesn't dis

Re: [HACKERS] Null row vs. row of nulls in plpgsql

2008-09-29 Thread Pavel Stehule
2008/9/29 Tom Lane <[EMAIL PROTECTED]>: > Greg Stark <[EMAIL PROTECTED]> writes: >> On 27 Sep 2008, at 09:56 PM, Tom Lane <[EMAIL PROTECTED]> wrote: >>> ISTM that the fundamental problem is that plpgsql doesn't distinguish >>> properly between a null row value (eg, "null::somerowtype") and a >>> ro

Re: [HACKERS] Null row vs. row of nulls in plpgsql

2008-09-28 Thread Tom Lane
Greg Stark <[EMAIL PROTECTED]> writes: > On 27 Sep 2008, at 09:56 PM, Tom Lane <[EMAIL PROTECTED]> wrote: >> ISTM that the fundamental problem is that plpgsql doesn't distinguish >> properly between a null row value (eg, "null::somerowtype") and a >> row of null values (eg, "row(null,null,...)::som

Re: [HACKERS] Null row vs. row of nulls in plpgsql

2008-09-28 Thread Hannu Krosing
On Sun, 2008-09-28 at 04:03 +0300, Greg Stark wrote: > Iirc the reason for this fuzziness came from the SQL spec definition > of IS NULL for rows. As long as you maintain that level of spec- > compliance I don't think there are any other important constraints on > pg behaviour. What does SQL

Re: [HACKERS] Null row vs. row of nulls in plpgsql

2008-09-28 Thread Greg Stark
Iirc the reason for this fuzziness came from the SQL spec definition of IS NULL for rows. As long as you maintain that level of spec- compliance I don't think there are any other important constraints on pg behaviour. greg --sorry for the top posting but the phone makes it hard to do anythi

Re: [HACKERS] Null row vs. row of nulls in plpgsql

2008-09-27 Thread Hannu Krosing
On Sat, 2008-09-27 at 14:56 -0400, Tom Lane wrote: > I looked a bit at the bug report here: > http://archives.postgresql.org/pgsql-bugs/2008-09/msg00164.php > > ISTM that the fundamental problem is that plpgsql doesn't distinguish > properly between a null row value (eg, "null::somerowtype") and a

[HACKERS] Null row vs. row of nulls in plpgsql

2008-09-27 Thread Tom Lane
I looked a bit at the bug report here: http://archives.postgresql.org/pgsql-bugs/2008-09/msg00164.php ISTM that the fundamental problem is that plpgsql doesn't distinguish properly between a null row value (eg, "null::somerowtype") and a row of null values (eg, "row(null,null,...)::somerowtype").