Re: [HACKERS] Handling NULL records in plpgsql

2008-10-25 Thread Dave Gudeman
On Sat, Oct 25, 2008 at 11:59 AM, Robert Haas <[EMAIL PROTECTED]> wrote: > > I really think we should have a way of telling if a array/row/record > > variable is actually set to something, and I'm pretty sure that should be > > unrelated to whether all the elements in it happen to be null. > > +1.

Re: [HACKERS] Handling NULL records in plpgsql

2008-10-25 Thread Robert Haas
> I really think we should have a way of telling if a array/row/record > variable is actually set to something, and I'm pretty sure that should be > unrelated to whether all the elements in it happen to be null. +1. Also, can whatever syntax we introduce by something relatively concise? Code tha

Re: [HACKERS] Handling NULL records in plpgsql

2008-10-24 Thread Tom Lane
Decibel! <[EMAIL PROTECTED]> writes: > ... I would argue that rowvar_b IS NOT NULL should be false and rowvar_a > IS NOT NULL should be true. While I don't necessarily disagree with you about what is sane, what is required by the SQL spec seems pretty clear here. regards

Re: [HACKERS] Handling NULL records in plpgsql

2008-10-24 Thread Decibel!
On Oct 24, 2008, at 7:19 PM, Tom Lane wrote: Decibel! <[EMAIL PROTECTED]> writes: Was anything ever done with http://archives.postgresql.org/pgsql- hackers/2008-09/msg01758.php ? No, we got stalled on what the behavior really ought to be: http://archives.postgresql.org/pgsql-hackers/2008-09/ms

Re: [HACKERS] Handling NULL records in plpgsql

2008-10-24 Thread Tom Lane
Decibel! <[EMAIL PROTECTED]> writes: > Was anything ever done with > http://archives.postgresql.org/pgsql-hackers/2008-09/msg01758.php ? No, we got stalled on what the behavior really ought to be: http://archives.postgresql.org/pgsql-hackers/2008-09/msg01772.php > I have a different issue I'm se

[HACKERS] Handling NULL records in plpgsql

2008-10-24 Thread Decibel!
Was anything ever done with http://archives.postgresql.org/pgsql- hackers/2008-09/msg01758.php ? I have a different issue I'm seeing, but I think it's related, and ISTM it's a bug (on 8.2.10): SELECT INTO v_prev * FROM installments_static WHERE id = (S