I have 2 tables where I need to update one column with the records from the other table: create table abc(id,b,c)as values ('ab1', 1, null) ,('ab2', 2, null) ,('ab3', 3, null) ,('ab4', 4, null) ; alter table abc add constraint…
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 two dates and I need to check that these two dates are within the same month of the same year. I have the following solution select to_char(:date1::date, 'yyyymm')::int2 = to_char(:date2::date, 'yyyymm')::int2 who has a better solution?
I'm attempting to set up a basic free tier AWS RDS postgres database. I have done this before, today. For some reason, I am suddenly unable to connect to any new databases I set up. I get this error when…
This is a strange test case from the Postgres regression test suite. It starts with a table named tenk, which has 10,000 rows in it. The table has a column called unique1, both of which contain values from 0 to…
I'm able to create the table using CTE with select statement like below but it's not behaving like I want. with sorting(item_code, index) as ( select (10001, 1), (10002, 2) ) select * from sorting Table result : item_code|index |…
I am needing to update several rows at a time through the Rest API for Postgres. The only way I have figured out how to do this is through a function call, where I pass the JSON to the function…
I have two SQL queries like this for postgresql: The first query is fetching subscriptions that were never synced or that were updated recently and synced a long time ago: SELECT * FROM subscriptions WHERE (last_sync_at IS NULL OR last_sync_at…
We have a requirement on production environment to run PR and DR as Active/Active. We have four nodes of redhat server. The request will be entertained from both sites means on both sites there should be a server who is…
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…