The Vertica Database Forums

Posted: **Wed Oct 23, 2013 3:20 am**

Hello,

Is there a difference between the SUBSTR() vs SUBSTRING() functions? There doesn't appear to be.

dbadmin=> select substr('whatisthedifference', 10), substring('whatisthedifference', 10);
   substr   | substring  
------------+------------
 difference | difference
(1 row)

Why do they both exist if they do the something?

Posted: **Wed Oct 23, 2013 8:08 am**

Hi!

[DELETED]

Posted: **Sun Oct 27, 2013 4:46 pm**

Sorry, skwa, call me stupid, but I still don't understand the difference. Even after reading the documentation. Keep in mind I'm a dba just out a college so I am a newbie to the extreme (pls be gentle).

The Vertica Database Forums

SUBSTR() vs SUBSTRING()

SUBSTR() vs SUBSTRING()

Re: SUBSTR() vs SUBSTRING()

Re: SUBSTR() vs SUBSTRING()