SHARE
TWEET

Untitled

a guest Jun 25th, 2019 58 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create type persona as (
  2.     nombre text,
  3.     apellidos text,
  4.     dni int
  5. );
  6.  
  7. create table casa (
  8.     familia persona[]
  9. );
  10.      
  11. insert into casa values (
  12.     array [
  13.         ('NombreFamiliar1', 'ApellidosFamiliar1', 012345678)::persona,
  14.         ('NombreFamiliar2', 'ApellidosFamiliar2', 012345678)::persona
  15.     ]
  16. );
  17.  
  18.  
  19. insert into casa values (
  20.     '{ "( "NombreFamiliar1", "ApellidosFamiliar1", 012345678 )", "( "NombreFamiliar2", "ApellidosFamiliar2", 012345678 )" }'
  21. );
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top