> I wrote:
> > Moving makeRowNullTest() doesn't seem like a big deal, but changing
> > ExecEvalNullTest would take some added code. Do we want to tackle that
> > during beta, or hold off till 8.3? An argument for doing it now is that
> > we just added nulls-in-arrays in 8.2, and it'd be good if t
Thank you for the explanation.
On Thu, 2006-09-28 at 12:06 -0400, Tom Lane wrote:
> Gevik Babakhani <[EMAIL PROTECTED]> writes:
> > Does this have anything to do with ExecEvalWholeRowVar?
>
> Yeah, the construct
>
> >> Seq Scan on int8_tbl x (cost=0.00..1.05 rows=1 width=16)
> >> Filter: (x.* I
I wrote:
> Moving makeRowNullTest() doesn't seem like a big deal, but changing
> ExecEvalNullTest would take some added code. Do we want to tackle that
> during beta, or hold off till 8.3? An argument for doing it now is that
> we just added nulls-in-arrays in 8.2, and it'd be good if the semanti
On Thu, Sep 28, 2006 at 11:45:32AM -0400, Tom Lane wrote:
> Teodor Sigaev <[EMAIL PROTECTED]> writes:
> > % echo 'SELECT count(*) FROM tst WHERE ROW(tst.*) IS NULL;' | psql wow
> > SET
> > count
> > ---
> > 0
> > (1 row)
>
> Hm, it turns out that this works:
> select * from int8_
Gevik Babakhani <[EMAIL PROTECTED]> writes:
> Does this have anything to do with ExecEvalWholeRowVar?
Yeah, the construct
>> Seq Scan on int8_tbl x (cost=0.00..1.05 rows=1 width=16)
>> Filter: (x.* IS NULL)
is really ExecEvalNullTest applied to the result of ExecEvalWholeRowVar.
If we simply p
Please excuse me for jumping in like this... but just for my
understanding...
Does this have anything to do with ExecEvalWholeRowVar?
On Thu, 2006-09-28 at 11:45 -0400, Tom Lane wrote:
> Teodor Sigaev <[EMAIL PROTECTED]> writes:
> > % echo 'SELECT count(*) FROM tst WHERE ROW(tst.*) IS NULL;' |
Teodor Sigaev <[EMAIL PROTECTED]> writes:
> % echo 'SELECT count(*) FROM tst WHERE ROW(tst.*) IS NULL;' | psql wow
> SET
> count
> ---
> 0
> (1 row)
Hm, it turns out that this works:
select * from int8_tbl x where row(x.q1,x.q2) is null;
but not this:
select * from int8
I'm playing around NULL. Docs says that
"A row value is considered not null if it has at least one field that is not
null." and "SELECT ROW(table.*) IS NULL FROM table; -- detect all-null rows"
So, I try:
wow=# \d tst
Table "public.tst"
Column | Type | Modifiers
---
