Re: Multidimensional arrays in plpgsql

From: "Celia McInnis" <celia(at)drmath(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Multidimensional arrays in plpgsql
Date: 2005-03-18 19:32:31
Message-ID: 20050318190144.M5262@drmath.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hmmmm - but a little uglier in my real application where the arrays are of
type TIMESTAMP.

Is there anything other than a valid timestamp that I can use for a timestamp
initializer - for instance some value that translates to epoch time, etc.?

Celia McInnis

> > Tom, are you recommending that I don't use multidimensional arrays until some
> > later version of postgres?
>
> No, just that you not try to put nulls in them ;-)
>
> Something like
> myarray1 INT[2][2]:=array[[0,0],[0,0]];
> woulda worked fine.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2005-03-18 19:44:28 Re: Multidimensional arrays in plpgsql
Previous Message Tom Lane 2005-03-18 19:27:56 Re: Array of Objects