How to remove n-first elements from array? - Mailing list pgsql-general

From aasat
Subject How to remove n-first elements from array?
Date
Msg-id 1355673672918-5736765.post@n5.nabble.com
Whole thread Raw
Responses Re: How to remove n-first elements from array?
List pgsql-general
Hi,

I have array for example

do $$
declare
  v_arr integer[] := array[1, 2, 3, 4, 5];
begin
end;
$$

I want to remove 2 first element and get array with non-changed indexes
(subscript)

new array := '[3:5]={3, 4, 5}'::integer[]

It is possible in pl/pgsql?



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-remove-n-first-elements-from-array-tp5736765.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Murray Cumming
Date:
Subject: Authenticate with hash instead of plaintext password?
Next
From: Peter Bex
Date:
Subject: Re: Authenticate with hash instead of plaintext password?