CHARINDEX () & PATINDEX () equivalent in PostgreSQL-CodePudding

Home > database > CHARINDEX () & PATINDEX () equivalent in PostgreSQL

CHARINDEX () & PATINDEX () equivalent in PostgreSQL

Time：10-21

I am trying to translate a T-SQL Query to PostgreSQL and one part of the query contains the string function CHARINDEX () which I am not able to translate to PgSQL.

Here is the part of the query with the string function:

SELECT 
                    REPLACE(REPLACE(SUBSTRING(
                        PARAMETRI
                        ,CHARINDEX('=',PARAMETRI, PATINDEX('


          
          
            Page link：https//www.codepudding.com/database/583244.html
          
          
               Prev:Split The Second String of Every Element in a List into Multiple Strings
               Next:How to get the unique string values in a column with numbers and characters in python


  
    
      
        
          
             Tags：  
stringpostgresql               
        
      
    
  
 
    
      
        
        	
            	Related
            
                       
        
      
    
  

  
    
      
        
           Links：  
          CodePudding

            
      
    
  


  About Us:          Contact Us      Terms of Service      
Privacy Policy
  Copyright © 2010-2023，Powered By CodePudding