substring(string [from int] [for int]) bytea Extract substring : substring « String Functions « PostgreSQL






  1. PostgreSQL
  2. String Functions
  3. substring

substring(string [from int] [for int]) bytea Extract substring


postgres=#
postgres=# -- substring(string [from int] [for int]) bytea Extract substring
postgres=# select substring('Th\\000omas'::bytea from 2 for 3);
 substring
-----------
 h\000o
(1 row)

postgres=#








Related examples in the same category

1.substring(s FROM n FOR l): Returns a character sub-string of the character
2.substring(name FROM 3 FOR 5)