Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres function - Mailing list pgsql-general

From David G. Johnston
Subject Re: postgres function
Date
Msg-id CAKFQuwaZ5YJVFpqoiH99oUF_G6U9FqzCgJao1nU-W9JJknA1bQ@mail.gmail.com
Whole thread Raw
In response to postgres function  (Ramesh T <rameshparnanditech@gmail.com>)
Responses Re: postgres function  (Ramesh T <rameshparnanditech@gmail.com>)
List pgsql-general
Tree view
On Wed, Oct 14, 2015 at 9:38 AM, Ramesh T <rameshparnanditech@gmail.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.

​

pgsql-general by date:

Previous
From: Jonathan Vanasco
Date:
Subject: Re: using postgresql for session
Next
From: Gavin Flower
Date:
Subject: Re: *** QUESTION *** After successful 'BEGIN;' command -- why PGSQL_TRANSACTION_ACTIVE and not PGSQL_TRANSACTION_INTRANS?