I have a query. It has an index but I'm not sure why it's taking time for fewer rows. Can anyone please suggest to improving that query performance? SELECT up.id post_id, c.id community_id, SUBSTRING(up.description, 1, 30) post_description, c.name community_name, c.is_index…
Help me to populate below columns as date without using to_date or to_char functions. day month year 1 2 1995 2 3 1998 5 6 2020 output date 01-02-1995 02-03-1998 05-06-2020
I have Postgres column of JSONB array of objects, looking like this : [{"key": "meetingDate", "value": "2022-08-22"}, {"key": "userName", "value": "Testing User"}] how can i get the result like this meetingDate userName 2022-08-22 TestingUser
I have a column createdAt which is datetype timestamp , I want to count how many records I have in that period. I try to group them by "DATE" However, I get an error: No function matches the given name…
I have table like follows col date a 2022-07-26 a 2022-07-27 c 2022-08-02 d 2022-07-28 and I would like to update value at latest date column update table set date = '2022-09-30' where col='a' and // some logic my desired…
I have a flights table and I need help on identifying whether the ticket number is one-way or round trip as seen in the image. Here are the specifications I need to satisfy: If there is only one coupon for…
I have T1 which is formatted as STUDENT SCORE DATE 1 6 2022-02-01 1 0 2022-03-12 1 5 2022-04-30 1 1 2022-04-30 1 1 2022-05-14 1 1 2022-05-19 1 8 2022-05-26 2 9 2022-01-02 2 10 2022-04-11 2 2 2022-04-12…
Essentially, I am wondering if there is a way to prevent adding duplicates for two columns. Consider a table with three columns, X, Y, and Z. I would like to be able to add entries with the same X value…
I want to have an array of distinct integer values across my postgres table as the return value of a stored function. The stored function currently looks like this create or replace function get_unique_entries(id int) returns table ("entry_id" int) language…
I've got following tables: Supplier idSupplier Name Product idProduct idSupplier EAN Now I want to select all values from both tables. I'm using this Query: SELECT Supplier.*, Product.* FROM Supplier INNER JOIN Product ON Supplier.idSupplier = Product.idSupplier The issue is,…