On Mar 25 10:11, george young wrote:
> On Mar 23 11:44, Don Maier <[EMAIL PROTECTED]> wrote:
> > Conversely, is it possible to construct a (single column) result set
> > from a select expression on a one-dimensional array with an unknown
> > number of elements?
>
> Not so easy without a custom
On Thu, 23 Mar 2006 11:44:32 -0800
Don Maier <[EMAIL PROTECTED]> threw this fish to the penguins:
> Is it possible to construct an array from an appropriate select
> expression that generates a result set of unknown cardinality?
> To focus on the simple case: Is it possible to construct a one-
> > Is an index on a nullable column useful for retrieving rows having that
> > column null?
>
> Nope, because IS NULL isn't an indexable operator.
>
> You can make an end-run around that with a partial index, eg
>
> create index fooi on foo(f1) where f1 is null
>
> This can be used to sa
given this.
create table AA (id serial,name varchar(15));
create table BB (id serial,name varchar(15));
insert into AA (name) values ('1243f');
insert into AA (name) values ('asdfef');
insert into AA (name) values ('fdbsfd');
insert into AA (nam
