Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  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. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement