Min and max element of an array column - Mailing list pgsql-sql

From Gianvito Pio
Subject Min and max element of an array column
Date
Msg-id 4A9E4FC0.1010908@gmail.com
Whole thread Raw
Responses Re: Min and max element of an array column  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-sql
Hello,
is it possible to obtain the minimum and the maximum single element of 
an array column?

Example:
[1, 2 ,5]
[3, -1, 6]
[9, 18,-4 ]

I'd just like to make a query that gives me the min (-4) and the max(18) 
of the column. Is that possible without a function? Thanks


pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: How to create Function which retruns username and password
Next
From: "A. Kretschmer"
Date:
Subject: Re: Min and max element of an array column