Re: Arrays - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Arrays
Date
Msg-id 20060126113824.P98620@megazone.bigpanda.com
Whole thread Raw
In response to Re: Arrays  (Bob Pawley <rjpawley@shaw.ca>)
List pgsql-general
On Thu, 26 Jan 2006, Bob Pawley wrote:

> Because it gives me an error otherwise.

What error?

insert into specifications values ('1', '{25, 50, 100, gpm}',
'{100, 250, 500, DegF}',
'{10, 40, 100, psi}', '{60, 120, 150, psi}' );

seems to insert fine for me given the table definition you gave.

> I am following the rules layed out in the documentation as follows -

Are you trying to do multidimensional arrays or just a set of single
dimensional ones?

pgsql-general by date:

Previous
From: Eric E
Date:
Subject: Re: Arrays
Next
From: Philippe Ferreira
Date:
Subject: Re: My very first PL/pgSQL procedure...