Re: [SQL] insert record in remote database

2010-10-24 Thread Osvaldo Kussama
2010/10/24 tejas tank : > Hello, >     Thanks a lot, >      This doc i have been read , i was thought it work but when i fire this > with my plsql on that time error message come that function is not define. > >    how to configure the postgres database so this module will enable >   is their any d

[SQL] How to search for a part of a number

2010-10-24 Thread Andreas
Hi, I'm wondering if there was a clever way to find parts of a numeric string in another table. There is a table that holds city-codes and city-names. City-code would be the part of a phone number that identifies the city. Over here this code can have 2 - 5 digits. So the table would contain: