[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] Return last value in of array (PostgreSQL 7.2.1)
From:       Erwin Brandstetter <Brsaz () gmzx ! at>
Date:       2003-09-29 19:03:40
[Download RAW message or body]

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.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
[prev in list] [next in list] [prev in thread] [next in thread]