I created a new age_date() function using the following SQL and C code: SQL: CREATE FUNCTION ag_catalog.age_date() RETURNS cstring LANGUAGE c STABLE PARALLEL SAFE AS 'MODULE_PATHNAME'; C Code: Datum age_date(PG_FUNCTION_ARGS) { // Program Logic } After stopping and restarting the…
Table A: (columns: id (integer), name (varchar), ...) Table B: (columns: id (integer), a_id (integer), value (numeric), ...) Table C: (columns: id (integer), a_id (integer), b_id (integer), date (date), ...) SELECT A.name, SUM(B.value) AS total_value, COUNT(DISTINCT C.date) AS distinct_dates FROM…
We are trying to get filtered custom field data out of the Moodle database via SQL query. Unfortunately it's necessary to join multiple tables to get the data we need, because Moodle keeps its data this way. Also we can't…
I'm trying to find a way to calculate the average of the first commented day vs the first approved day of this data set. I've narrowed it down to one PR that I'd like to work on but I'd like…
I'm trying to modify the max_function_args parameter in PostgreSQL, but I'm getting an error message saying that the parameter cannot be changed. I'm using PostgreSQL version X.X on operating system Y. I've checked my user role and confirmed that I…
In python I have a list of tuples Each tuple has four fields, the first field is the row identifier that would be used in a where clause in a SQL update statement. tuple: (id, status, department, manager_email) update_tuple_list =…
Let's say I have a database with columns name, last_name and type They're all strings, though type can only be TYPE_A, TYPE_B or TYPE_C I want a row in the database to be Unique when name and last_name already exist.…
There is a set of users. A person can have multiple users, but ref1 and ref2 might be alike and can therefore link users together. ref1 and ref2 does not overlap, one value in ref1 does not exist in ref2.…
I am using SQLAlchemy ORM and trying to figure out how to produce a PostgreSQL query like the following: SELECT resources.* FROM histories, jsonb_array_elements_text(histories.reported_resources) as report_resource_name JOIN resources ON resources.resource_name = report_resource_name WHERE histories.id = :id So far I got…
I use DBSCHEMA tool and want to execute a query but I got this error: syntax error at or near "id" position 209 Code: CREATE TABLE user_info ( id UUID PRIMARY KEY, full_name VARCHAR NOT NULL, birthday VARCHAR NOT NULL,…