Posts by GabuCarrneiro • 1 point
2 posts
-
0
votes1
answer150
viewsA: Exercise involving Function in Postgresql
The answer I’ve found so far would be this INSERT INTO CONTRATO(CLIENTE_ID, TELEFONE_ID, DATA_CONTRATO, PLANO_ID, VALOR_FINAL) values ( CLI_ID, ( SELECT TEL2.ID FROM CONTRATO CON2 INNER JOIN…
-
0
votes1
answer150
viewsQ: Exercise involving Function in Postgresql
The question would be as follows: With the following Bank: Telefone (id, numero, operadora_id) Cliente (id, cpf, nome, rg, sexo, uf) Operadora (id, nome, cnpj) Contrato(id, cliente_id, telefone_id,…