Re: using replace function

2019-12-02 Thread Antonio Silva
Hi Osvaldo, Rod, David and Tom Thanks for your attention. Lastly it is not that difficult. For me the more natural way is Rod's suggestion, to use replace with where. I don't know why I didn't think of this solution. The usage of regexp_replace is very nice too and I will take a time to learn i

using replace function

2019-11-28 Thread Antonio Silva
Hello list I want to replace a string (not a substring) in a field but making sure that the string in the full field. In the example below since 'blue' is not the full text in 'blue shark' there should not have a replacement. How to say "replace only with 'blue' if it is the full string in the f

Re: issues when installing postgres

2018-05-10 Thread Antonio Silva
-to-thoroughly-purge-and-reinstall-postgresql-on-ubuntu And life goes on ... All the best Antonio Olinto 2018-05-09 21:15 GMT-03:00 Tim Cross : > > > On 10 May 2018 at 09:45, Adrian Klaver wrote: > >> On 05/09/2018 02:47 PM, Antonio Silva wrote: >> >>> Hello

Re: issues when installing postgres

2018-05-09 Thread Antonio Silva
Hello Adrian Are you using the Ubuntu or Postgres repos? > I'm using the Ubuntu repos Can you connect to Postgres using psql? > No I cannot Thanks Antonio 2018-05-09 10:36 GMT-03:00 Adrian Klaver : > On 05/08/2018 05:54 PM, Antonio Silva wrote: > >> Hello! >>

issues when installing postgres

2018-05-08 Thread Antonio Silva
Hello! I bought a new computer and I installed Ubuntu 18.04 and after PostgreSQL. sudo apt install postgresql postgresql-contrib pgadmin3 Nevertheless I had some issues with configuration files and decided to uninstall it completely sudo apt purge postgresql postgresql-contrib pgadmin3 When I in