Movatterモバイル変換

Question 1

-1votes

1answer

72views

Adding CHECK Constraint Without Error and Duplication [duplicate]

I have implemented this code to add a check constraint after creating the tableALTER TABLE recruitment_data.candidate_experiences ADD CONSTRAINT chk_experience_dates CHECK ( ...

Beliz Yazici

31

askedNov 20 at 11:52

Question 2

3votes

2answers

130views

How to properly constrain two-dimensional array types to be square in Ada?

I'm trying to create a package of generic adjacency matrices to define graphs, and the first goal is to define a static version based on two-dimensional array:with Ada.Containers.Vectors;generic ...

tymurmchyk

71

askedOct 16 at 15:47

Question 3

0votes

0answers

70views

Composite key (ts, deviceid) with timeseries container

I’m on GridDB Cloud (Free). For a TimeSeries container, I want each device to have at most one row per timestamp, i.e., enforce uniqueness on (ts, deviceid).Schema:CREATE TABLE TSDB ( ts TIMESTAMP ...

Badhon Ashfaq

907

askedOct 4 at 14:25

Question 4

-2votes

2answers

147views

Split N people in X constrained groups with Google Sheets

[EDIT]Hi everyone,I am looking for clues to work out a sorting formula with Sheets.We are planning "teambuilding" school trips at our international college. I need to split a list of 200+ ...

peritus

9

askedSep 20 at 20:40

Question 5

6votes

2answers

185views

Enforce CRTP via Constraint in C++

I'd like to enforce a CRTP template parameter to be an actual derived type. Unfortunately it seems to be impossible to express that as a constraint.The problem is that the constrained type is ...

Bernd

2,469

askedSep 15 at 12:47

Question 6

0votes

1answer

63views

System verilog constraint for queues with fixed number of 6s

Can someone help me with system verilog constraint for the below requirement.1) Fixed queue size of 10 and has four 6s in it at random position.I tried the below constraint to start with.class ...

User99

11

askedSep 15 at 10:19

Question 7

1vote

1answer

73views

Adding constraints to deriving declarations

I have this datatypenewtype Dimension a b = MkDimension bWhenever it is properly formatted (e.g. satisfies the format constraint), I want to derive a set of classes. I do not want a Dimension which ...

Ashok Kimmel

381

askedSep 8 at 19:11

Question 8

0votes

2answers

82views

How to make UIView fit the size of its contents?

I have the following code func setupUI() { self.view.backgroundColor = .white let titleLbl = UILabel() titleLbl.text = book.title titleLbl.textColor = .black ...

Chris Hansen

8,781

askedSep 8 at 13:33

Question 9

1vote

0answers

32views

How can you use GRASP to solve a bi-objective optimization problem (in assembly line balancing)?

My problem is:I have to optimize my collaborative assembly line with solving a bi-objective optimization model using metaheuristics. We chose to start with GRASP.The two objectives are to minimize ...

Hind Bhr

19

askedAug 26 at 11:51

Question 10

1vote

1answer

113views

Why is this Deferred Constraint Trigger Raising an Exception on the Not Final State of the Record

Why is my deferred constraint checking an intermediate state and not the final state of the record?We use PostgreSQL 16.9 for our database and we use Python3 and Psycopg2 to manage our data pipeline....

Marissa

13

askedAug 23 at 7:28

Question 11

4votes

3answers

127views

Why can't Haskell unify my types when using a constraint as class parameter?

I am trying to split my code into nice modules. However, while doing this, one of the classes I have in the imported module (Outer in Module 1 below) needs a constraint that is only known in the ...

Niek Janssen

150

askedAug 20 at 12:26

Question 12

2votes

2answers

142views

Use function on foreign key constraint

Can I have a foreign key constraint that takes a timestamp column but uses it as date only?I'm trying something like this but it doesn't work:alter table table1 add constraint my_constraint ...

runnerpaul

7,564

askedAug 8 at 11:42

Question 13

4votes

1answer

72views

Constrained type is unconstrained?

I've been writing Rust for a several months now, and I've come across this headscratcher:I have the following code:trait MyTrait {}impl MyTrait for String {}impl MyTrait for str {}impl MyTrait ...

lilHar

1,883

askedJul 29 at 19:44

Question 14

0votes

0answers

45views

Bayesian model in SAS Proc MCMC - how to specify parameter constraints

I am trying to estimate a Bayesian logistic model (with a latent variable and two comparison groups, apart from model parameters), while specifying that two parameters should be equal. My SAS code ...

user2450223

247

askedJul 21 at 21:29

Question 15

0votes

0answers

25views

How to add unique constraint in multiple column?

example: I have a clazz table, with name and package name, the two columns need unique together.class clazz { long id; // primary key QString name; // class ...

Shaobin Qian

1

askedJul 8 at 3:32

Movatterモバイル変換

Collectives™ on Stack Overflow

Adding CHECK Constraint Without Error and Duplication [duplicate]

How to properly constrain two-dimensional array types to be square in Ada?

Composite key (ts, deviceid) with timeseries container

Split N people in X constrained groups with Google Sheets

Enforce CRTP via Constraint in C++

System verilog constraint for queues with fixed number of 6s

Adding constraints to deriving declarations

How to make UIView fit the size of its contents?

How can you use GRASP to solve a bi-objective optimization problem (in assembly line balancing)?

Why is this Deferred Constraint Trigger Raising an Exception on the Not Final State of the Record

Why can't Haskell unify my types when using a constraint as class parameter?

Use function on foreign key constraint

Constrained type is unconstrained?

Bayesian model in SAS Proc MCMC - how to specify parameter constraints

How to add unique constraint in multiple column?

Hot Network Questions

Subscribe to RSS