Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group