I'm trying to call 2 columns from 2 different tables. applicants.ic_no and agents.ic_no. It have different values. Using the following codes only displayed only ic_no from agents.ic_no $claimLists = ClaimDetail::join('applicants', 'applicants.ic_no', '=', 'claim_details.ic_no') ->join('agents', 'agents.id', '=', 'claim_details.agent_id') ->where('claim_date', $cutt_off) ->groupBy('agents.id',…
Most of the blogs and stacks suggests below database for chat. message_table -id -message -conversationId -sender -receiverId conversation_table -id -conversationId Now message_table look like this. So, for the chat screen I subscribe the message table. final mySubscription = supabase .from('message_table')…
Brief I'm getting inserts into a transactions log table out of desired (logical) order - where a deposit to a an accountinstance+iteration occurs before that iteration exists, logically. Technology We're using PostgreSQL (13.x). Background I'm writing code that must be…
My context: I need creating an web-app use ASP.NET Core WebAPI .NET 6, Entity Framework Core 6, PostgreSQL 14.5 with JWT authentication/authorization. I mimics a sample at https://github.com/patrickgod/AuthenticationWebApi , then fork to me https://github.com/donhuvy/AuthenticationWebApi . This source code use .NET…
I recently upgraded brew and part of it was an update to PostgreSQL. The update was successful, brew suggested to move older files to a different folder (I don't remember the exact line right now). Now when I try to…
I have two database tables. What I need to do is to copy specific data from one storage to another, but also keep the mapping to the photos. First part I can do easily writing INSERT INTO item (storage_id, price,…
I am attempting to insert some data into my database via a lambda function. I am getting the following error ForeignKeyViolation: insert or update on table "address" violates foreign key constraint "address_id_fkey" I understand that this is because my address…
I'm implementing a dialogs search module on a messaging app. Retrieving the list of dialogs names would be as follows: select coalesce(c.custom_name, u.username) as dialog_name from user_chats uc join chats c using(chat_id) left join users u on uc.peer_id = u.user_id…
I am doing a query on a very large data set and i am using WITH (CTE) syntax.. this seems to take a while and i was reading online that temp tables could be faster to use in these cases…
Trying to get the length of array in array. RAISE NOTICE '%', a[1][2][1]; -- ok, returns proper value RAISE NOTICE '%', array_length(a, 1); -- ok, returns array length But this won't work: RAISE NOTICE '%', array_length(a[1], 1); -- Error: function…