select max(to_number(ltrim(aefo_number,'VE'))) from exemption where aefo_number like 'E%' or aefo_number like 'V%' I am getting Function to_number(text) does not exist error for the above select statement and I am unable to convert it. If anyone know the syntax for the…
Lets say I have function that triggers when table is being updated. Then it tries to send this data as json into remote database via dblink: statement := 'INSERT INTO mytable(my_data) VALUES (''' || my_json || ''')'; PERFORM dblink('my connection…
I have this query ` CREATE TABLE Commitment_fees (user_id INT PRIMARY KEY AUTO_INCREMENT, amount INT, success INT, date DATE); ALTER TABLE Commitment_fees AUTO_INCREMENT=1000; INSERT INTO Commitment_fees (amount, success, date) VALUES (1000, 1, '2021-01-01'), (1010, 0, '2021-01-01'), (200, 1, '2021-01-01'), (201,…
in my Laravel app I have 3 tables : users, documents and type_documents, the user have multiple documents and document have one type_document | Documents | | -------- | | id | | file | | type_document_id| | user_id |…
I use PostgreSQL 14 to work on a student_books table which manages books borrowed by students. Each student can have zero or more books borrowed at any point in time. The table look like this (the order of rows doesn't…
I have a JSON column, telework, stored in Postgres which looks like "{ ..., "biweeklyWeek1-locationMon": "alternative", "biweeklyWeek1-locationTues": "agency", "biweeklyWeek1-locationWeds": "alternative", "biweeklyWeek1-locationThurs": "alternative", "biweeklyWeek1-locationFri": "alternative", ... , "biweeklyWeek2-locationMon": "alternative", "biweeklyWeek2-locationTues": "agency", "biweeklyWeek2-locationWeds": "alternative", "biweeklyWeek2-locationThurs": "alternative", "biweeklyWeek2-locationFri": "alternative", ... }" I need…
I have table data after doing all joins and restrictions like this: Name Type Path Item 1 mobile /mobile/image1.jpg Item 1 desktop /desktop/image1.jpg Item 2 mobile /mobile/image2.jpg Item 2 desktop /desktop/image2.jpg I want the result table to look like this…
I am trying to give a service principal SELECT access on my Azure Synapse SQL data. CREATE USER [MY_SERVICE_PRINCIPAL] FROM EXTERNAL PROVIDER WITH DEFAFULT_SCHEMA=[dbo] GO GRANT SELECT ON DATABASE :: MyDB TO [MY_SERVICE_PRINCIPAL]; This works fine, but it requires me…
I want to 'group by' beers so that they are grouped together, with the respect aggregate rating and tasters (people who review the beers) listed in separate columns. Here is my code: create or replace view tasters_avg_ratings1 as select a.taster…
{ "List1": [ { "f1": "b6ff", "f2": "day", "f3": "HO", "List2": [{"f1": 1.5,"f2": "RATE"}] }] } This is nested JSON in which there's a list 'List2' inside another list 'List1'. how to filter f1 = 1.5 in List2? I have…