Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Trim UK Postcodes in PostgresSQL

Language: Layout:
absolute service time: 0,39 sec 
edit mode |  history 
  
postcode
sector
district
area



1
B1 1AB
B1 1
B1
B



2
W1A 1AB
W1A 1
W1A
W



3
WV14 1AB
WV14 1
WV14
WV



4
GIR 1AB
GIR 1
GIR
GI






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development