Skip site navigation (1) Skip section navigation (2)

Re: Pet Peeves?

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Pet Peeves?
Date: 2009-01-30 17:31:55
Message-ID: 20090130173155.GW3008@frubble.xen.chris-lamb.co.uk (view raw or flat)
Thread:
Lists: pgsql-general
On Thu, Jan 29, 2009 at 01:16:17PM +0000, Gregory Stark wrote:
> So, what do people say? Is Postgres perfect in your world or does it
> do some things which rub you the wrong way?

 * "anonymous records" are a tad annoying to use
   SELECT (1,2,3) ORDER BY 1;
   SELECT ARRAY[(1,2,3)];
   SELECT MIN((1,2,3));
     or maybe this is more obvious:
     SELECT MIN(x) FROM (VALUES (1,2,3)) x;

 * VALUES assumes it's returning a tuple, making the following too verbose:

     SELECT * FROM (VALUES (1),(2),(3),(4)) x;

 * Arrays of arrays don't work; we only get multi-dimensional arrays.

   as a sub-point, the semantics of multi-dimensional arrays are too
   complicated and it would be nice if at least the arity of the array
   was included in its type

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

In response to

  • Pet Peeves? at 2009-01-29 13:16:17 from Gregory Stark

pgsql-general by date

Next:From: Daniel VeriteDate: 2009-01-30 17:41:38
Subject: Re: Pet Peeves?
Previous:From: Steve CrawfordDate: 2009-01-30 17:20:37
Subject: Re: Pet Peeves?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group