Hacker News Reader

Comment by perl4ever | Hacker News Reader

I can't think offhand of a language that does overload + for strings by default.

  Perl uses .
  Oracle SQL uses ||
  Microsoft SQL and VBA use &
  C obviously doesn't use +.
  Neither does Pascal.
  Power Query doesn't.

> Microsoft SQL and VBA use &

Nope, Microsoft SQL uses +.

> C obviously doesn't use +.

But C++ does for std::string.

> Neither does Pascal.

Original Pascal didn't, but I think most modern Pascals do (e.g. Object Pascal known from Delphi).

>Nope, Microsoft SQL uses +.

I was referring to Access.

>Original Pascal didn't, but I think most modern Pascals do

I'm pretty sure concat() was used in THINK and Metrowerks Pascal in the 90s.

Pascal does, at least in all the more common dialects.

VBA (and VB in general) overloads "+" for strings in addition to providing "&", the difference being mostly in what gets converted to what in various situations: https://docs.microsoft.com/en-us/office/vba/language/referen...

Is there any reason anyone in their right mind would use + that way in VBA?

I've seen plenty of code in VBA and VB6 that does so. I think it stems mostly from & being a late addition to BASIC (earlier BASICs only had +).

C# does, as do quite a few others. Heh, this is kind of interesting:

Java and Python, from the top of my head, allow "str1" + "str2"

C#, GoLang, Javascript, Python, and Ruby are several.

Python and Ruby even overload *, for the dubiously useful construction:

"hello" * 3 == "hellohellohello"

I like Julia's standard string concat which subverts a Python user's intuition: "string1" * "string2" == "string1string2". Why? Because monad.

JavaScript, Python, Ruby, Go all use +.