Re: Return last value in of array (PostgreSQL 7.2.1)

From: Erwin Brandstetter <Brsaz(at)gmzx(dot)at>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Return last value in of array (PostgreSQL 7.2.1)
Date: 2003-09-29 19:03:40
Message-ID: Xns9405D60CE839DBrandstetterFalterat@213.129.232.14
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message lgama@sagitario.cic.ipn.mx 2003-09-29 19:59:27 remove my email account, please
Previous Message Lamar Owen 2003-09-29 17:59:09 Re: [ADMIN] postgres 6.2 vacuum