Re: [GENERAL] Problem with Select output

2004-12-22 Thread Fernando Schapachnik
sleect function(ssd_a) from ... where function is one of the built-in text function or one of your own written in some of the supported (by your version) procedure languages. Regards. En un mensaje anterior, srini vasan escribió: > --- srini vasan <[EMAIL PROTECTED]> wrote: > > > Hi > >I a

Re: [GENERAL] Problem with Select output

2004-12-22 Thread Alvaro Herrera
On Wed, Dec 22, 2004 at 07:50:56AM -0800, srini vasan wrote: Hi, >Can anybody please help me in this? You could use the replace(text,text,text) function: alvherre=# create table foo (a text); CREATE TABLE alvherre=# insert into foo values ('hola alvherre'# '); INSERT 155224 1 alvherre=# sel

Re: [GENERAL] Problem with Select output

2004-12-22 Thread srini vasan
Hi all Can anybody please help me in this? Regards Srini --- srini vasan <[EMAIL PROTECTED]> wrote: > Hi >I am facing some issues with select query. The > values of the columns in one table contains "\n" as > a > part of the value. So when I execute the select > query > on this table,

[GENERAL] Problem with Select output

2004-12-22 Thread srini vasan
Hi I am facing some issues with select query. The values of the columns in one table contains "\n" as a part of the value. So when I execute the select query on this table, I am getting the following output. # select * from stdhlr_subscriber_profile ; subscriber_id | ssd_a ---+-