Is there a difference between the SUBSTR() vs SUBSTRING() functions? There doesn't appear to be.
Code: Select all
dbadmin=> select substr('whatisthedifference', 10), substring('whatisthedifference', 10);
substr | substring
------------+------------
difference | difference
(1 row)