pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedJagged/ragged arrays
5+ messages / 3 participants
[nested] [flat]
* Jagged/ragged arrays
@ 2010-09-20 08:54 Florian Weimer <fweimer@bfk.de>
2010-09-20 19:42 ` Re: Jagged/ragged arrays Dmitriy Igrishin <dmitigr@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Florian Weimer @ 2010-09-20 08:54 UTC (permalink / raw)
To: pgsql-sql
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 <fweimer@bfk.de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Jagged/ragged arrays
2010-09-20 08:54 Jagged/ragged arrays Florian Weimer <fweimer@bfk.de>
@ 2010-09-20 19:42 ` Dmitriy Igrishin <dmitigr@gmail.com>
2010-09-21 04:58 ` Re: Jagged/ragged arrays Craig Ringer <craig@postnewspapers.com.au>
0 siblings, 1 reply; 5+ messages in thread
From: Dmitriy Igrishin @ 2010-09-20 19:42 UTC (permalink / raw)
To: Florian Weimer <fweimer@bfk.de>; +Cc: pgsql-sql
Hey Florian,
What do you mean by "ragged" arrays?
--
Regards,
Dmitriy
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Jagged/ragged arrays
2010-09-20 08:54 Jagged/ragged arrays Florian Weimer <fweimer@bfk.de>
2010-09-20 19:42 ` Re: Jagged/ragged arrays Dmitriy Igrishin <dmitigr@gmail.com>
@ 2010-09-21 04:58 ` Craig Ringer <craig@postnewspapers.com.au>
2010-09-21 07:19 ` Re: Jagged/ragged arrays Florian Weimer <fweimer@bfk.de>
2010-09-21 07:19 ` Re: Jagged/ragged arrays Dmitriy Igrishin <dmitigr@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Craig Ringer @ 2010-09-21 04:58 UTC (permalink / raw)
To: Dmitriy Igrishin <dmitigr@gmail.com>; +Cc: Florian Weimer <fweimer@bfk.de>; pgsql-sql
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-related writing at http://soapyfrogs.blogspot.com/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Jagged/ragged arrays
2010-09-20 08:54 Jagged/ragged arrays Florian Weimer <fweimer@bfk.de>
2010-09-20 19:42 ` Re: Jagged/ragged arrays Dmitriy Igrishin <dmitigr@gmail.com>
2010-09-21 04:58 ` Re: Jagged/ragged arrays Craig Ringer <craig@postnewspapers.com.au>
@ 2010-09-21 07:19 ` Florian Weimer <fweimer@bfk.de>
1 sibling, 0 replies; 5+ messages in thread
From: Florian Weimer @ 2010-09-21 07:19 UTC (permalink / raw)
To: Craig Ringer <craig@postnewspapers.com.au>; +Cc: Dmitriy Igrishin <dmitigr@gmail.com>; pgsql-sql
* Craig Ringer:
> 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?
Yes, this is what I'm after.
--
Florian Weimer <fweimer@bfk.de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Jagged/ragged arrays
2010-09-20 08:54 Jagged/ragged arrays Florian Weimer <fweimer@bfk.de>
2010-09-20 19:42 ` Re: Jagged/ragged arrays Dmitriy Igrishin <dmitigr@gmail.com>
2010-09-21 04:58 ` Re: Jagged/ragged arrays Craig Ringer <craig@postnewspapers.com.au>
@ 2010-09-21 07:19 ` Dmitriy Igrishin <dmitigr@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Dmitriy Igrishin @ 2010-09-21 07:19 UTC (permalink / raw)
To: Craig Ringer <craig@postnewspapers.com.au>; +Cc: Florian Weimer <fweimer@bfk.de>; pgsql-sql
Hey Craig, Florian
Ahh, this. Why not just yes NULLs as values of array?
2010/9/21 Craig Ringer <craig@postnewspapers.com.au>
> 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-related writing at http://soapyfrogs.blogspot.com/
>
--
Regards,
Dmitriy
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2010-09-21 07:19 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-09-20 08:54 Jagged/ragged arrays Florian Weimer <fweimer@bfk.de>
2010-09-20 19:42 ` Dmitriy Igrishin <dmitigr@gmail.com>
2010-09-21 04:58 ` Craig Ringer <craig@postnewspapers.com.au>
2010-09-21 07:19 ` Florian Weimer <fweimer@bfk.de>
2010-09-21 07:19 ` Dmitriy Igrishin <dmitigr@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox