On psql, I could call format() with 'Hello World' as shown below: postgres=# SELECT format('Hello World'); format ------------- Hello World (1 row) Now, dividing 'Hello World' into 'Hello ' and 'World' in one line with one space got the error…
I was told that it's better to have many rows of data instead of many columns in DB. I need a DB for transactional application, and intend to use PostgreSQL DB. As far as I understand I have these two…
I have a table with close to 10000 rows I want to update the first 500 rows using SQL UPDATE gs_user_objects_copy SET user_id = '269' WHERE user_id = '14' LIMIT 500 I want to change the user_id to 269 where…
I am using AWS Redshift. I have a table that looks like this: Id key value1 value2 value3 1 xxx A NULL NULL 1 xxx NULL B NULL 2 uuu NULL NULL C If the id is repeating, the entire…
I need to insert data into new table person_department using recursion. My tables for now: person id group_id 800 10 805 21 department id name group_id parent_id 1 ABC 10 5 2 TY 11 5 5 OOO null 9 6…
I cannot get prefix search to work on a scalar field. I can however get infix search to work which suggests that my field is not properly tokenized. ENV: Standalone Milvus 2.4.8 on Ubuntu 22.04 Here is my schema: {…
I need help with the DB query builder. I tried to check if such a relationship already exists but got an error saying Call to undefined method IlluminateDatabaseQueryBuilder::has() $startDate = Carbon::today()->format('Y-m-dT00:00:00'); $endDate = Carbon::today()->format('Y-m-dT23:59:59'); if (request('start_date') && request('end_date')) { $startDate…
I have a table race_racer that contains time serialized logs for each racer in a race. I am trying to select the lastest record for a given racer in x number of races prior to a date. Basically selecting their…
I need to make a python script using a query and params formatted as a list of dicts to use the execute function on the engine object. The script that I have been trying only returns -1: db_type = "mssql+pyodbc"…
I have a PostgreSQL query that aggregates data from multiple tables and generates a report. Currently it works perfectly fine and it is quite simple. Here is the query I'm using: SELECT a.name AS account_name, c.name AS campaign_name, ad.name AS…