Re: Pet Peeves?

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/