Re: postgres function - Mailing list pgsql-general

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'

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...