Return-Path: X-Original-To: apmail-tajo-dev-archive@minotaur.apache.org Delivered-To: apmail-tajo-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 1AC7510FC1 for ; Sun, 1 Dec 2013 06:05:04 +0000 (UTC) Received: (qmail 29416 invoked by uid 500); 1 Dec 2013 06:05:03 -0000 Delivered-To: apmail-tajo-dev-archive@tajo.apache.org Received: (qmail 29332 invoked by uid 500); 1 Dec 2013 06:05:00 -0000 Mailing-List: contact dev-help@tajo.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@tajo.incubator.apache.org Delivered-To: mailing list dev@tajo.incubator.apache.org Received: (qmail 29323 invoked by uid 99); 1 Dec 2013 06:04:59 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 01 Dec 2013 06:04:59 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with SMTP; Sun, 01 Dec 2013 06:04:57 +0000 Received: (qmail 28420 invoked by uid 99); 1 Dec 2013 06:04:35 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 01 Dec 2013 06:04:35 +0000 Date: Sun, 1 Dec 2013 06:04:35 +0000 (UTC) From: "hyoungjunkim (JIRA)" To: dev@tajo.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (TAJO-342) Implement strpos(string, substring) function MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/TAJO-342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hyoungjunkim updated TAJO-342: ------------------------------ Attachment: TAJO-342.patch I implemented strpos. Please review this patch. > Implement strpos(string, substring) function > -------------------------------------------- > > Key: TAJO-342 > URL: https://issues.apache.org/jira/browse/TAJO-342 > Project: Tajo > Issue Type: New Feature > Components: operator/function/udf > Reporter: Hyunsik Choi > Assignee: hyoungjunkim > Priority: Minor > Fix For: 0.8-incubating > > Attachments: TAJO-342.patch > > > h3. Function Definition > {code} > int strpos(string text, substring text) > {code} > h3. Description > This function finds the location of specified substring. > * If *string* or *substring* is null, the result should be null. > * If *substring* is '', the result should be 1. > * If there is no matched *substring*, the result should be 0. > * The result is one-based index. > h3. Example. > {code} > hyunsik=> select strpos('tajo','jo'); > strpos > -------- > 3 > (1 row) > {code} -- This message was sent by Atlassian JIRA (v6.1#6144)