I have a two part question We have a PostgreSQL table with a jsonb column. The values in jsonb are valid jsons, but they are such that for some rows a node would come in as an array whereas for…
i have query like this, but displays wrong last_message. $users = Message::join('users', function ($join) { $join->on('messages.from_id', '=', 'users.id') ->orOn('messages.to_id', '=', 'users.id'); }) ->where(function ($q) { $q->where('messages.from_id', auth()->user()->id) ->orWhere('messages.to_id', auth()->user()->id); }) ->where('users.id','!=',auth()->user()->id) ->select([ 'users.id', 'users.name', 'users.avatar', DB::raw('MAX(messages.created_at) max_created_at'), DB::raw('MAX(messages.body) last_message'), DB::raw('CASE…
As the title says, I clones a rails API. I tried to follow the steps in this article from point 2 onwards https://dev.to/w3ndo/a-checklist-for-setting-up-a-cloned-rails-application-locally-5468 but I keep getting the same error from db:setup onwards. Please help! I have tried googling the…
Let's say I have two tables called schools and students which have a one-to-many relationship. Each student can only be in one school but each school can have many students. school ----------- id name student ----------- id name school_id I…
I store all my secrets and database params in the dev.env file. I have 3 different settings files - base, dev and prod. There is an SQLite database in base, and I want to connect to Postgres in dev. So…
How to check the last record of a user in supabase. I would only need by means of the user ID to find his last record "date" in a descending way I have something like the following, but this would…
I'm new to SQL and I would like to to group by ID and create another column based on value. Let me give an example: Foreign ID Type Value 1 'X' 10 1 'Y' 20 2 'X' 30 2 'Y'…
I need to add column in table called value which needs to store value from 0 to 1 up to 2 decimal points i.e. 0.25 0.50 0.75 0.80 etc.. Can anyone help with this? Thanks in advance
Need help with postsql query field matching a certain domain names in the end as per below in a particular FIELD. 1234.abc.xyz.com; 0971.abc.xyz.com WHERE CAST (domain_name AS text) LIKE '%d{4}.abc.xyz.com%' #where domain_name is the FIELD name
In PostgreSQL using jsonb column, is there a way to select / convert an attribute with actual datatype the datatype instead of getting it as a string object when using jsonpath? I would like to try to avoid cast as…