Write a postgre sql query to display the first word in the job title if the job title contains more than one words

SELECT job_title,  SUBSTR(job_title,1, POSITION(' ' IN job_title)) 
FROM jobs;

Sample table: jobs

+------------+---------------------------------+------------+------------+
| JOB_ID     | JOB_TITLE                       | MIN_SALARY | MAX_SALARY |
+------------+---------------------------------+------------+------------+
| AD_PRES    | President                       |      20000 |      40000 |
| AD_VP      | Administration Vice President   |      15000 |      30000 |
| AD_ASST    | Administration Assistant        |       3000 |       6000 |
| FI_MGR     | Finance Manager                 |       8200 |      16000 |
| FI_ACCOUNT | Accountant                      |       4200 |       9000 |
| AC_MGR     | Accounting Manager              |       8200 |      16000 |
| AC_ACCOUNT | Public Accountant               |       4200 |       9000 |
| SA_MAN     | Sales Manager                   |      10000 |      20000 |
| SA_REP     | Sales Representative            |       6000 |      12000 |
| PU_MAN     | Purchasing Manager              |       8000 |      15000 |
| PU_CLERK   | Purchasing Clerk                |       2500 |       5500 |
| ST_MAN     | Stock Manager                   |       5500 |       8500 |
| ST_CLERK   | Stock Clerk                     |       2000 |       5000 |
| SH_CLERK   | Shipping Clerk                  |       2500 |       5500 |
| IT_PROG    | Programmer                      |       4000 |      10000 |
| MK_MAN     | Marketing Manager               |       9000 |      15000 |
| MK_REP     | Marketing Representative        |       4000 |       9000 |
| HR_REP     | Human Resources Representative  |       4000 |       9000 |
| PR_REP     | Public Relations Representative |       4500 |      10500 |
+------------+---------------------------------+------------+------------+

Output:

pg_exercises=# SELECT job_title,  SUBSTR(job_title,1, POSITION(' ' IN job_title))
pg_exercises-# FROM jobs;
            job_title            |     substr
---------------------------------+-----------------
 President                       |
 Administration Vice President   | Administration
 Administration Assistant        | Administration
 Finance Manager                 | Finance
 Accountant                      |
 Accounting Manager              | Accounting
 Public Accountant               | Public
 Sales Manager                   | Sales
 Sales Representative            | Sales
 Purchasing Manager              | Purchasing
 Purchasing Clerk                | Purchasing
 Stock Manager                   | Stock
 Stock Clerk                     | Stock
 Shipping Clerk                  | Shipping
 Programmer                      |
 Marketing Manager               | Marketing
 Marketing Representative        | Marketing
 Human Resources Representative  | Human
 Public Relations Representative | Public
(19 rows)