Search Postgresql Archives

Re: Array constructor requires one argument

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Jan 09, 2007 at 04:09:21PM -0500, Tom Lane wrote:
> Joe Conway <mail@xxxxxxxxxxxxx> writes:
> > Unless we can convince ourselves that array-of-UNKNOWN is not dangerous, 
> > I don't think this is easily solved.
> 
> One possibility that might handle Martijn's problem is to allow the
> construct
> 
> 	ARRAY[]::type[]
> 
> that is, you can have an empty ARRAY construct only if you immediately
> cast it to a specific array type.  The application typically knows what
> type the data is anyway, and if it just always plasters on the cast then
> the syntax would work regardless of whether there are any elements or not.

+1 for doing it this way :)

Cheers,
D
-- 
David Fetter <david@xxxxxxxxxx> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux