I want to store such fields in the table as: the ID of the employee, his last name and first name, and how many hours he worked on each day of the month. For example, March 1 - 6 hours,…
I've been trying to insert a case statement into my create function statement and haven't had any luck. Just a heads up I am using pgadmin and postgresql. I have a table with rental movie titles, along with an integer…
SELECT * FROM destinations; id | updated_at | created_at | name | image --------------------------------------+----------------------------+----------------------------+----------------------------------------------+---------------------------------------------------- cf534cd9-56dd-43d5-87bb-713538ec748d | 2023-08-08 23:44:42.822226 | 2023-08-08 23:44:42.822226 | Afghanistan | https://x.cloudfront.net/flags/af.svg af4e3ac4-e9a6-4c17-8077-664d896f3a7f | 2023-08-08 23:44:42.822226 | 2023-08-08 23:44:42.822226 | Aland Islands | https://x.cloudfront.net/flags/ax.svg b377b81e-3a0c-4768-84c4-bba67e3bae1b | 2023-08-08…
I use concatenation to prepare a query string with parameter values When I use single quotes: p_ReqStr_old := ' with prm as ( select 1::int4 as id, ' || ' to_timestamp(''' || to_char(p_BegRepDate, 'DD.MM.YYYY') || ''',''DD.MM.YYYY'')::timestamp as p_BegDate, to_timestamp(''' ||…
In my system, a lot of data has accumulated in a table. Now I don't understand how to delete them. Then I realized that I need to use partitions, but I can't go back in time. Today i have 10…
While installing Apache AGE from master branch, on PostgreSQL 14, the following error appeared while issuing make install: /usr/bin/install: cannot remove '/usr/local/pgsql/lib/age.so': Permission denied make: *** [/usr/local/pgsql/lib/pgxs/src/makefiles/../../src/Makefile.shlib:456: install-lib-shared] Error 1 What should I do to fix this? What I tried…
Table: CREATE SEQUENCE vars_id_seq; CREATE TABLE vars ( id INT PRIMARY KEY NOT NULL DEFAULT nextval('vars_id_seq'), name VARCHAR(30) NOT NULL, value VARCHAR(30) ); ALTER SEQUENCE vars_id_seq OWNED BY vars.id; I inserted some rows, and all was well. Today, however, when…
I have a PostgreSQL table with the following structure: CREATE TABLE cte1 ( entity_id INT, assignedtogroup INT, time BIGINT ); INSERT INTO cte1 (entity_id, assignedtogroup, time) VALUES (1, 435198, 1687863949740), (1, 435198, 1687863949741), (1, NULL, 1687863949742), (1, NULL, 1687863949743), (1,…
I am using .NET 6 and PostgreSQL database. I have a hosted service, which periodically calls repository's function and is querying database entities using EF Core as so: public class NotificationRepository : INotificationRepository { public async Task<List<Notification>> GetUnreadDeviceNotifications() { using…
Many of the columns in different tables in my database have the constraint between 1 and 3 (equivalent to any (array[1,2,3]) since they're all integers). This may need to be changed to allow 4s in the future, so I want…