Re: array syntax and geometric type syntax

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: array syntax and geometric type syntax
Date: 2009-08-13 16:50:20
Message-ID: 20090813165020.GF5407@samason.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2009-08-13 16:51:44 Re: PostgreSQL for Firefox Bookmarks?
Previous Message Tom Lane 2009-08-13 16:48:38 Re: totally different plan when using partitions