I have a table in Postgres with the structure bellow. id name objects(jsonb) 1 first [{"name":"a", value:"1", "param":{}}, {"name":"b", "value":"55", "param":{}}, {"name":"c", "value":"234", "param":{}}] 2 second [{"name":"b", "value":"22", "param":{}}, {"name":"c", "value":"24", "param":{}}] 3 third [{"name":"c", "value":"345", "param":{}}] | 4 forth…
How are you doing? I'm currently using PostgreSQL and want to create a 'where' with just a specif date but the value returns me a kind of timestamp. Example of the json: What the json looks like: {"key1": {"key2": "2023-02-13T13:28:49.087000Z"}}…
I'm using Psycopg3 (not 2!) and I can't figure out how can I connect to a remote Postgres server psycopg.connect(connection_string) https://www.psycopg.org/psycopg3/docs/ Thanks!
I need to write an Openedge 11.6.4 ABL procedure that automatically: Connects to a PostgreSQL database. Read some info and write it in my OpenEdge DB. Disconnect from PostgreSQL. My problem is in the connection part. Is that possible?
I have a table in a postgres database whose columns are shown below. CREATE TABLE Student( name VARCHAR, course_id SMALLINT[] ); I am trying to write a SQL query that fetches the name of the Student that has course_id 1…
I have created a stored procedure in Postgres CREATE OR REPLACE PROCEDURE reset_disabled() LANGUAGE plpgsql AS $$ DECLARE BEGIN UPDATE regional_price_info SET disabled = NULL; END; $$; I tried to call procedure from the repository class in two ways however…
I have table like follows. id is sequential number and they order ascending. id score name 1 10 A 2 20 B 3 30 C 4 40 D I would like to calculate subtotal by using specific variable for example…
So im reading through the apacheAGE regression tests and specifically this one https://github.com/apache/age/blob/master/regress/expected/age_global_graph.out and I've noticed that the ID returned for each vertex is the same. As far as i know the databases use different IDs to track the object.…
Can someone help me understand what this SQL query is doing? select region_code, ST_Area(geom::geography) as area, ST_X(ST_Centroid(geom)) as long, ST_Y(ST_Centroid(geom)) as lat, latitude, longitude from regions where regexp_split_to_array(parent, E'\\.') && %s or region_code in %s More specifically I'm confused about…
Trying to translate a uint256 number which is encoded as a 64-char / 256-bit hex. Eventually the result should be stored in a numeric(78,0) which is enough to encode an uint256. For smaller hex-strings there's pretty direct ways to encode…