Re: array syntax and geometric type syntax - Mailing list pgsql-general

From Sam Mason
Subject Re: array syntax and geometric type syntax
Date
Msg-id 20090813165020.GF5407@samason.me.uk
Whole thread Raw
In response to Re: array syntax and geometric type syntax  ("Dan Halbert" <halbert@halwitz.org>)
List pgsql-general
On Thu, Aug 13, 2009 at 12:31:29PM -0400, Dan Halbert wrote:
> Perhaps I should have mentioned that initially.

In retrospect everything is easy!

>   SELECT ARRAY[1,2,1+2]::INT[];
> works fine.

I'd not put a cast into that one.  I can't see any performance reason
why it's bad, I think it's mainly because it may mask other problems
later on.  It's not going to affect much fundamental either way though.

--
  Sam  http://samason.me.uk/

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: totally different plan when using partitions
Next
From: "Joshua D. Drake"
Date:
Subject: Re: PostgreSQL for Firefox Bookmarks?