select array(select array[1,2]);
give me an error: "could not find array type for data type integer"?
Is there a type-cast missing, or is this generally impossible? I was
expecting something like
In my real-world application, the subquery returns more than one pair
of ints, but I think it all boils down to this simpler example. I am
using version 7.4 of PostgreSQL.
Thanks a lot,
pgsql-sql by date
|Next:||From: Enrico Weigelt||Date: 2005-05-02 03:55:53|
|Subject: Re: pgtop, display PostgreSQL processes in `top' style|
|Previous:||From: Enrico Weigelt||Date: 2005-05-02 03:41:00|
|Subject: Re: trigger/rule question|