How to extract from row by index in sql?

Question

PostgreSQL

SELECT substring('Guru99' from 1 for 4)
4 characters are extracted from the first position,
but I need characters 1 and 3 to be extracted.

Answer 1

substring is not intended for such manipulations. First extract the first character, then the third. You can combine the result together and write it to a variable.