Tom Lane wrote:
Martijn van Oosterhout <kleptog@svana.org> writes:
On Tue, Jan 09, 2007 at 10:02:09AM -0500, Tom Lane wrote:
Define the data type of
SELECT ARRAY[];
The same type as:
SELECT NULL;
Hardly, because whatever type NULL has, it's not an array type.
Here's a link to the initial discussion on this topic:
http://archives.postgresql.org/pgsql-hackers/2003-06/msg01195.php
Unless we can convince ourselves that array-of-UNKNOWN is not dangerous,
I don't think this is easily solved.
Joe
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
