Postgres 11

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE stock_prices(composit VARCHAR(100))

CREATE TABLE

INSERT INTO stock_prices
VALUES('a.US'),('b'), ('c.US')

INSERT 0 3

CREATE INDEX idx ON stock_prices(REVERSE(composit));

CREATE INDEX

explain (analyze,buffers)SELECT * FROM stock_prices WHERE REVERSE(composit) LIKE REVERSE('%.US');

QUERY PLAN

Seq Scan on stock_prices  (cost=0.00..1.04 rows=1 width=218) (actual time=0.032..0.035 rows=2 loops=1)

  Filter: (reverse((composit)::text) ~~ 'SU.%'::text)

  Rows Removed by Filter: 1

  Buffers: shared hit=1

Planning Time: 0.552 ms

Execution Time: 0.063 ms

EXPLAIN