Skip to content

Instantly share code, notes, and snippets.

@derwolfe

derwolfe/gist:b917892855bf80fb31c4b86d8a31c496

Created March 10, 2017 15:51
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save derwolfe/b917892855bf80fb31c4b86d8a31c496 to your computer and use it in GitHub Desktop.
Save derwolfe/b917892855bf80fb31c4b86d8a31c496 to your computer and use it in GitHub Desktop.
Download ZIP
cast array elements
Raw
gistfile1.txt
> create table spam(spot inet[]);
> insert into spam values (ARRAY['192.168.1.1'::inet]);
> account_service=> select * from spam;
spot
---------------
{192.168.1.1}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment