Casper TL
Reputation: 348
PostgreSQL: Check if row exists or another row has a specific value
I have the following tables:
When a new ComputerComponents is created, the database should check and only allow the insertion IF one is true:
- ComputerComponent has a component which is a ComponentType with name = 'GPU'
OR
- ComputerComponent has a component which is a ComponentType with name = 'CPU' AND the CPU has a Attribute with name = 'Onboard-GPU' and the ComponentAttribute value = TRUE
How do i do this?
Upvotes: 1
Views: 153
Answers (1)
Related Questions
- Check value if exists in column
- PostgreSQL check if value exists in another table
- checking if a value exists in another table within the SELECT clause
- check if row exists with specific value
- I am having problems to use EXISTS or PERFORM in a function to find out whether a row exists or not
- Check to see if a record exists postgres function
- PostgreSQL Return Row if Value Exists in One of Several Columns
- How do I write a function that return True iff row exist?
- Only return value when row exists in SQL
- Check if a row exists or not in postgresql