search

awsdocs / amazon-redshift-developer-guide

This is the documentation for the Amazon Redshift Developer Guide
Other
121 stars 143 forks source link

clarify relationship between substring functions #58

Closed richardharrington closed 1 year ago

richardharrington commented 3 years ago

Description of changes:

The three functions STRPOS, CHARINDEX, and POSITION are for the same purpose (to get the index of a substring in a string), but they are described as "synonyms" currently in the docs, which they are not, in the sense that they do not have identical meanings (the argument structures for all three of them are different). The word "synonym" is confusing because it implies that they are aliases of each other.

So here we say "similar", and also we take off the note at the bottom of one of them saying to look to the other one for "details". They all have pretty much the same information and examples, so that's not really necessary or helpful. And their relationship is flagged at the top of the article anyway.

By submitting this pull request, I confirm that you can use, modify, copy, and redistribute this contribution, under the terms of your choice.

keithhc2 commented 2 years ago

@richardharrington Apologies for the delay here, and thanks for your help! We've created a ticket in our internal system, so we're going to see whether we need to update the docs and act accordingly with your PR.

joshbean commented 1 year ago

Closing this issue or pull request in advance of archiving this repo. For more information about the decision to archive this repo (and others in the 'awsdocs' org), see the announcement on the AWS News Blog.