Re: Arrays

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Bob Pawley <rjpawley(at)shaw(dot)ca>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Arrays
Date: 2006-01-26 19:43:36
Message-ID: 20060126113824.P98620@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

  • Re: Arrays at 2006-01-26 19:23:18 from Bob Pawley

Responses

  • Re: Arrays at 2006-01-26 20:06:38 from Bob Pawley
  • Re: Arrays at 2006-01-26 20:07:09 from Bob Pawley

Browse pgsql-general by date

  From Date Subject
Next Message Philippe Ferreira 2006-01-26 20:04:25 Re: My very first PL/pgSQL procedure...
Previous Message Eric E 2006-01-26 19:41:44 Re: Arrays