From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | paulo matadr <saddoness(at)yahoo(dot)com(dot)br> |
Cc: | GENERAL <pgsql-general(at)postgresql(dot)org>, Sql-listas_post <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Enc: Help to replace caracter |
Date: | 2008-11-14 16:39:21 |
Message-ID: | 491DA9B9.7060703@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
On 14/11/2008 16:17, paulo matadr wrote:
> Any help me to create pgPL/sql or funcion to replace ( " ) to null
> value, I have many table with this.
Do you mean you want to replace just those characters with NULL? Won't
this cause the entire string to be NULL?
postgres=# select 'abc' || NULL;
?column?
----------
(1 row)
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Marco Antonio | 2008-11-14 16:55:25 | Re: Enc: Help to replace caracter |
Previous Message | Serge Fonville | 2008-11-14 16:34:35 | Re: [JDBC] Re : [pgadmin-support] trouble in installing postgreSQL 8.3 |
From | Date | Subject | |
---|---|---|---|
Next Message | Marco Antonio | 2008-11-14 16:55:25 | Re: Enc: Help to replace caracter |
Previous Message | Sabin Coanda | 2008-11-14 16:27:44 | raise doesn't add end of line |