What is wrong?

From: Wei Weng <wweng(at)kencast(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: What is wrong?
Date: 2001-09-28 19:45:48
Message-ID: 1001706359.11935.4.camel@Monet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi there. I wrote a simple postgresql sql function as follows:

create function test() returns integer as '
begin
fixed_path := translate (''/text'', ''\\'', ''/'');
raise notice ''fixed_path:'', fixed_path;
return 1;
end
' language 'plpgsql';

And when I ran it as

pgsql>select test();

I got:

NOTICE: plpgsql: ERROR during compile of test near line 8
ERROR: unterminated string starting on line 10

What is wrong? (something fishy about translate function?) Could anyone
enlighten me on this?

Thank you very much!

Wei

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-09-29 06:19:21 Re: What is wrong?
Previous Message Michael Remme 2001-09-28 14:46:47 Re: TEXT in select