replace " with nothing
| От | Tony Capobianco |
|---|---|
| Тема | replace " with nothing |
| Дата | |
| Msg-id | 1305145780.1954.4.camel@tony1.localdomain обсуждение исходный текст |
| Ответы |
Re: replace " with nothing
Re: replace " with nothing Re: replace " with nothing |
| Список | pgsql-sql |
We are converting from Oracle to Postgres. An Oracle script contains this line: select replace(firstname,'"'), memberid, emailaddress from members; in an effort to replace the " with nothing. How can I achieve the same result with Postgres? Here's the Postgres error I get: select replace(firstname,'"'), memberid, emailaddress from members; ERROR: function replace(character varying, unknown) does not exist LINE 1: select replace(firstname,'"'), memberid, emailaddress from m... Thanks.
В списке pgsql-sql по дате отправления: