Re: Multidimensional arrays in plpgsql - Mailing list pgsql-novice

From Celia McInnis
Subject Re: Multidimensional arrays in plpgsql
Date
Msg-id 20050318190144.M5262@drmath.ca
Whole thread Raw
In response to Re: Multidimensional arrays in plpgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Multidimensional arrays in plpgsql
List 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.


pgsql-novice by date:

Previous
From: "Erik Dahlstrand"
Date:
Subject: Re: [despammed] Destination table by variable?
Next
From: Tom Lane
Date:
Subject: Re: Array of Objects