The order for the array is Min, Norm, Max, Unit.
I'll probably reorder it with the unit first as every value has a unit.
Bob
----- Original Message -----
From: "Tino Wildenhain" <tino@wildenhain.de>
To: "Joshua D. Drake" <jd@commandprompt.com>
Cc: "Bob Pawley" <rjpawley@shaw.ca>; "Stephan Szabo"
<sszabo@megazone.bigpanda.com>; "Tom Lane" <tgl@sss.pgh.pa.us>; "Postgresql"
<pgsql-general@postgresql.org>
Sent: Thursday, January 26, 2006 12:30 PM
Subject: Re: [GENERAL] Arrays
> Joshua D. Drake schrieb:
>> Bob Pawley wrote:
>>
>>> ERROR: malformed array literal: "{100, 250, 500, DegF)"
>>
>>
>> Well you have a typo:
>>
>> "{100, 250, 500, DegF)" is wrong...
>>
>> "{100, 250, 500, DegF}" is correct...
>>
> I'd say both are wrong ;)
> '{100,250,500,DegF}' could work. But I'm not sure about that
> DegF. Since array members are all of the same type - is degf
> some integer constant?
>
> Regards
> Tino
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend