On 21/09/2010 3:42 AM, Dmitriy Igrishin wrote:
Hey Florian,
What do you mean by "ragged" arrays?
At a guess:
craig=> SELECT '{ {1}, {1,2}, {1}, {1,2,3} }'::integer[][];
ERROR: multidimensional arrays must have array expressions with
matching dimensions
(OP) Correct?
--
Craig Ringer
Tech
Hey Florian,
What do you mean by "ragged" arrays?
--
Regards,
Dmitriy
Hello again, Michele,
I haven't open my mailbox during weekend so I couldn't follow up your
question.
It would help if you explain a little better the background of the problem
you're trying to solve.
You want to find all the user IDs which have the same value on a given time
interval?
I
It seems that PostgreSQL 8.4 does not support ragged arrays. Is there
a workaround to get similar functionality (mainly the ability to
extract values in SQL expressions)?
--
Florian Weimer
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721
True,
but it still allowed me to write queries that I do not know how to
express otherwise.
Am 20.09.10 01:58, schrieb Tom Lane:
> =?UTF-8?B?SmFubiBSw7ZkZXI=?= writes:
>> Ok I now know that it really seems to do what I expected. But I still
>> wonder what it does if I use two functions f() and g(