shubhi
Reputation: 9
Defaults in sql
Can we have multiple default values according to conditions stated for each default in postresql?
Like Can we have different defaults according to a entry of a column for each insert.
Upvotes: 0
Views: 40
Answers (1)
Laurenz Albe
Reputation: 246013
A column default cannot depend on other columns in the table. You probably need a BEFORE INSERT trigger.
Upvotes: 1
Related Questions
- SQL default row values
- SQL query to insert default values
- Default Value in a column when insert a new row
- How to make a table column always use the default value during insertion?
- Insert Row into Postgresql Table with Only Default Values
- INSERT INTO with default values for a single column
- How to retrieve the actual default value for a column before insertion
- insert DEFAULT values
- How to insert value into a column with a default value? [PostgreSQL 9.1]
- Set default value of one column to another column in INSERT Statement