I have a database table with content like this: Id Label GroupId DueDate Amount 1 (null) A 1/1/2023 100.00 2 (null) A 1/2/2023 101.00 3 L1 A 1/3/2023 102.00 4 L1 A 1/4/2023 103.00 5 (null) B 1/3/2023 104.00 6…
Objective: I want a single query to return either the default value OR a configured value based on the input parameter. Example: I have a default email I want to send out for all my sources. However, I want to…
I have data in the following form select t.name_field, t.value_field from ( values ('name_1', 'val_fld_1'), ('name_2', null), ('name_3', 'val_fld__3') ) as t(name_field,value_field); From this data, I need to get a json string of the following form: {"name_1" : [{"value" :…
I have 4 entities : User(id*, ...) Permission(user_id*, resource_id*, resource_type, role) Resource1(id*, ...) Resource2(id*, ...) Resource1 and Resource2 share no semantic relation and are completely independant. How can I force my database to ensure that Permission.resource_id exists in one and…
this error occurs when I run the PG installcheck of AGE marcos@Marcos:~/new-age/age$ make PG_CONFIG=~/age_project/postgres/bin/pg_config installcheck /home/marcos/age_project/postgres/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=./ --bindir='/home/marcos/age_project/postgres/bin' --load-extension=age --inputdir=.//regress --outputdir=.//regress --temp-instance=.//regress/instance --port=61958 --encoding=UTF-8 --dbname=contrib_regression scan graphid agtype catalog cypher expr cypher_create cypher_match cypher_unwind cypher_set cypher_remove cypher_delete cypher_with cypher_vle cypher_union…
I'm getting this error when trying to 'UPDATE' my module through odoo interface to try to install the ir.cron Traceback (most recent call last): File "/home/odoo-it1/odoo/versions/16.0/odoo/odoo/tools/cache.py", line 85, in lookup r = d[key] File "<decorator-gen-6>", line 2, in __getitem__ File…
AGE's functions can be found in the age--1.3.0.sql file. Although there are no examples of function overloading, is there any possibility to create multiple functions with the same name but with different parameters for AGE? If yes, then how? If…
What JPA + Hibernate data type should I use to support vector extension in postgres database, so that it allows me to create embeddings using a JPA Entity CREATE TABLE items (id bigserial PRIMARY KEY, embedding vector(3)); https://github.com/pgvector/pgvector
for some reason japanese characters are not being stores correctly in my database, on shell is coming up as x1a and in pgadmin just squares. I found out after I was getting constraint violation when inserting records, and then I…
I was hoping to get answer for an old post, but it seems my necromancy skills are not powerful yet. So, the question is what is "unused RAM" in the PostgreSQL database server? For example; with a PostgreSQL database serverwith…