ERROR: malformed array literal: "{100, 250, 500, DegF)"
I want to do single dimension arrays.
How did I turn it into multidmensional?
Bob
----- Original Message -----
From: "Stephan Szabo" <sszabo@xxxxxxxxxxxxxxxxxxxxx>
To: "Bob Pawley" <rjpawley@xxxxxxx>
Cc: "Tom Lane" <tgl@xxxxxxxxxxxxx>; "Postgresql"
<pgsql-general@xxxxxxxxxxxxxx>
Sent: Thursday, January 26, 2006 11:43 AM
Subject: Re: [GENERAL] Arrays
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?
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
