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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2009-01-30 17:41:38 Re: Pet Peeves?
Previous Message Steve Crawford 2009-01-30 17:20:37 Re: Pet Peeves?