Postgres Pro
Downloads
Home   >   mailing lists

How do I get min and max from an array of floating point values - Mailing list pgsql-sql

From pw
Subject How do I get min and max from an array of floating point values
Date
Msg-id 48BDACC7.3070302@telus.net
Whole thread Raw
Responses Re: How do I get min and max from an array of floating point values
List pgsql-sql
Tree view 
Hello,

Is it possible to get the min and max from an array of
floating point values?

The following doesn't return the min of the array values
it simply returns the complete array...(??)

SELECT min(string_to_array('1,2,3,4,5,6,7',',')::float[]);

Thanks

Peter

pgsql-sql by date:

Previous
From: "Richard Broersma"
Date:
Subject: Re: order of rows in update
Next
From: "Claus Guttesen"
Date:
Subject: seemingly slow for-loop in plpgsql