I have the below SQL that takes only data from the Name column up to the point where a space or hyphen appears. I would like to order the results by the output of the case statement but can't find…
I have this table: id period_type period commission 123456 Daily 10 10 123456 Monthly 3 11 123456 Daily 5 12 123456 Monthly 1 13 123457 Monthly 6 14 123457 Daily 5 15 123457 Monthly 9 16 (Period type is int…
I want to save in Postgres TIMESTAMP WITH TIME ZONE column 2012-08-24 14:00:00+03:00 After a SELECT I am getting: 2012-08-24 11:00:00+00:00 I know that my DB is on UTC zone, but is there a way to save it and not…
I can’t write a condition that will allow me to count the total number of lines, divide them by the number of lines that contain the word Tetris and display the result of the division Trying Select count(*) From table_name…
How do I tell PostgreSQL this? :: Get me the highest-ranked result for every element in a group, ranked by these attributes that you can already find in an index, so you don't have to rank the entire table. See…
I have an expense table where multiple expenses can be tied to an ID, but each of these expenses can have a specific type. I can get the sum of ONE type. SELECT SUM(expense) AS total FROM expenses WHERE id…
I have the following postgres query that's meant to update all message entries: update message m set user_id = u.id from "user" u where u.user_pgid = m.user_pgid The trouble is that I have ~300,000,000 message records, and postgres seems to…
Working with jsonb and Postgres I'm running into the following problem: My output looks like this: [ {columnName: {}}, { columnName: {} } ] But I would like it to look like this: [ {}, {} ] I want to…
I'm starting working on json columns in google bigquery. My aim is to implement a query which: extracts a given value in the json object based on path and returns its real SQL value. Example: given {"foo": {"bar": 123}}, I'd…
I'm running a code written for Snowflake SQL dialect on database with DuckDB(Postgres) dialect. I need to dispatch the functions that do not exist in the target one. For example I have error regarding endswith function - it's available in…