Posts by Madson Rocha • 15 points
4 posts
-
0
votes1
answer51
viewsQ: How to instantiate a constructor variable (to be Primary key) within the table?
The question is misspelled, but the problem is this. I’m working with BDOR in the Postgresql. I created two Types and I’m adding them to Type animal. Soon after, I used Inheritance and created the…
-
0
votes0
answers1410
viewsQ: Error inserting in table: "Missing FROM-clause entry for table..."
I have three tables: CREATE TABLE Bebidas( id SERIAL primary key, nome varchar(40) NOT NULL, preco_bebidas decimal(5,2) check (preco_bebidas > 0.00), qntd int); CREATE TABLE Shots( id SERIAL…
-
0
votes2
answers62
viewsQ: Optimization in SQL
Is there any way to improve that stretch?
-
0
votes2
answers118
viewsQ: Basic SQL (Join and Where)
Good night, I’m trying to solve a problem which is this:: Tables: editoras (cod int primary key, nome varchar (50)); autores (cod int primary key, nome varchar (50)); livros (isbn char (13), titulo…