SUBSTR() vs SUBSTRING()

Moderator: NorbertKrupa

Post Reply
User avatar
bud
Newbie
Newbie
Posts: 14
Joined: Fri Oct 11, 2013 1:45 am

SUBSTR() vs SUBSTRING()

Post by bud » Wed Oct 23, 2013 3:20 am

Hello,

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)
Why do they both exist if they do the something?
Bud Anderson

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: SUBSTR() vs SUBSTRING()

Post by id10t » Wed Oct 23, 2013 8:08 am

Hi!

[DELETED]
Last edited by id10t on Sat May 09, 2015 3:32 pm, edited 1 time in total.

User avatar
bud
Newbie
Newbie
Posts: 14
Joined: Fri Oct 11, 2013 1:45 am

Re: SUBSTR() vs SUBSTRING()

Post by bud » 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).
Bud Anderson

Post Reply

Return to “Vertica SQL Functions”