Re: postgres function

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thu, Oct 15, 2015 at 3:15 PM, Ramesh T <rameshparnanditech@xxxxxxxxx> wrote:

yes David gave correct solution

but , the value I'm using  and  it's column in the table sometimes value  may be '123-987-123' or '123-987-123-13-87'

​So adapt the answer provided to match your data.​

if pass like below must return else condiion 0,

select case when select split_part('123-987-123','-',4) >0

then 1 else 0 end 

it's return error like integer need...

​I have no clue what you are trying to say here...

David J.

​