Re: how to use array with "holes" ? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: how to use array with "holes" ?
Date
Msg-id 162867790706010323h1ead51f8r7a8652ee888c780d@mail.gmail.com
Whole thread Raw
In response to Re: how to use array with "holes" ?  (Anton <anton200@gmail.com>)
Responses Re: how to use array with "holes" ?  (Anton <anton200@gmail.com>)
List pgsql-general
>
> May I ask some more complex? I want to use ONE multidimensial array -
> the "id", "bytes_in" and "bytes_out". By another words, I need an
> array, each element of which must contain 3 values: ttc_id, bytes_in,
> bytes_out.
>
> I think it can be done like this:
>

It's problem. You have to wait for 8.3 where composite types in arrays
are supported, or simply use three array variables (or use plperl or
plpython). Arrays in plpgsql can be slow, if you often update big
arrays.

pgsql-general by date:

Previous
From: "Dmitry Koterov"
Date:
Subject: Re: Does slonik EXECUTE SCRIPT call waits for comands termination?
Next
From: Anton
Date:
Subject: Re: how to use array with "holes" ?