Same with
inet datatype.
Like in a radius db:
SELECT "radacctid", "acctsessionid", "acctuniqueid", "username", "groupname", "realm", SUBSTR("nasipaddress", 1, 256), "nasportid", "nasporttype", "acctstarttime", "acctstoptime", "acctsessiontime", "acctauthentic", "connectinfo_start", "connectinfo_stop", "acctinputoctets", "acctoutputoctets", "calledstationid", "callingstationid", "acctterminatecause", "servicetype", "xascendsessionsvrkey", "framedprotocol", SUBSTR("framedipaddress", 1, 256), "acctstartdelay", "acctstopdelay" FROM "public"."radacct" LIMIT 1000;
/* ERROR: function substr(inet, integer, integer) does not exist
LINE 1: ...tuniqueid", "username", "groupname", "realm", SUBSTR("na...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts. */
Hint use
SUBSTR("`inet or whatever type column`"::varchar, 1, 256)