I have an ltree column containing a tree with a depth of 3. I'm trying to write a query that can select all children at a specific depth (level 1 = get all parents, 2 = get all children, 3 = get all g...

I have a table with large amount of 'S wrongly added and I want to replace it for 's: I have tried with replace(field, ''S', ''s') but obviously doesn't accept it for the ', I also tried with the $$...

I need to update 2 columns in table with same conditions. I know, that each of them would take a lot of time. How can I concatenate 2 updates into 1, which can be faster? -- first update update t1 set...

I have a table with address all in capital but I am trying to format it like this: 145 WELLBEING STREET, PARADE, LONDON, PP1 5PP 145 Wellbeing Street, Parade, London, PP1 5PP How can i work with that?...