Skip to content

Instantly share code, notes, and snippets.

@kovid-rathee

kovid-rathee/array_by_index_postgresql.sql

Last active February 24, 2019 09:29
Show Gist options
  • Save kovid-rathee/e2586da2cd2fc9dbf2d2ffb95b5e68c0 to your computer and use it in GitHub Desktop.
Save kovid-rathee/e2586da2cd2fc9dbf2d2ffb95b5e68c0 to your computer and use it in GitHub Desktop.
Download ZIP
Getting an array element by Index
Raw
array_by_index_postgresql.sql
create table array_fn (test_array text[]);
insert into array_fn values ('{This,Is,What,Bothers,Me}');
select test_array[3]::varchar from array_fn;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment