Re: how to use array with "holes" ?

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: Anton <anton200(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how to use array with "holes" ?
Date: 2007-06-01 10:23:00
Message-ID: 162867790706010323h1ead51f8r7a8652ee888c780d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2007-06-01 10:58:18 Re: warm standby server stops doing checkpoints after awhile
Previous Message Dmitry Koterov 2007-06-01 09:41:05 Re: Does slonik EXECUTE SCRIPT call waits for comands termination?