Re: postgres function

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Ramesh T <rameshparnanditech(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgres function
Date: 2015-10-14 19:24:41
Message-ID: CAKFQuwaZ5YJVFpqoiH99oUF_G6U9FqzCgJao1nU-W9JJknA1bQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 14, 2015 at 9:38 AM, Ramesh T <rameshparnanditech(at)gmail(dot)com>
wrote:

> Hi All,
> Do we have function like regexp_substr in postgres..?
>
> in oracle this function seach the - from 1 to 2 and return result,
> regexp_substr(PART_CATG_DESC,'[^-]+', 1, 2)
>

​Maybe one of the functions on this page will get you what you need.

http://www.postgresql.org/docs/devel/static/functions-string.html

David J.

​

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gavin Flower 2015-10-14 19:33:02 Re: *** QUESTION *** After successful 'BEGIN;' command -- why PGSQL_TRANSACTION_ACTIVE and not PGSQL_TRANSACTION_INTRANS?
Previous Message Jonathan Vanasco 2015-10-14 19:16:18 Re: using postgresql for session