Re: Return last value in of array (PostgreSQL 7.2.1) - Mailing list pgsql-admin

From Erwin Brandstetter
Subject Re: Return last value in of array (PostgreSQL 7.2.1)
Date
Msg-id Xns9405D60CE839DBrandstetterFalterat@213.129.232.14
Whole thread Raw
In response to Return last value in of array (PostgreSQL 7.2.1)  (Erwin Brandstetter <Brsaz@gmzx.at>)
List pgsql-admin
Not that it makes much of a difference, but i guess the following code
might work slightly better:

r[(substring(array_dims(r), strpos(array_dims(r), ':') + 1,
(length(array_dims(r)) - strpos(array_dims(r), ':')) - 1))::int]


Regards
Erwin Brandstetter
--
no z in my mail.

pgsql-admin by date:

Previous
From: Erwin Brandstetter
Date:
Subject: Re: Return last value in of array (PostgreSQL 7.2.1)
Next
From:
Date:
Subject: