Trevor Sullivan•17mo ago

How do I use a Windmill Postgres script to insert a date field?

I tried this script, and it fails with the error message: ExecutionError: error serializing parameter 2: cannot convert between the Rust type alloc::string::String and the Postgres type date``

-- $1 firstName
-- $2 lastName
-- $3 regDate
INSERT INTO customers (first_name, last_name, registration_date)
  VALUES ($1::TEXT, $2::TEXT, $3) RETURNING *

-- $1 firstName
-- $2 lastName
-- $3 regDate
INSERT INTO customers (first_name, last_name, registration_date)
  VALUES ($1::TEXT, $2::TEXT, $3) RETURNING *

1 Reply

rubenf•17mo ago

Yes you have to type the date like you did the other fields