[SQL] What is wrong?

2001-09-28 Thread Wei Weng 

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


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: [SQL] simple question!

2001-09-28 Thread Josh Berkus 

Esteban,

>  is there a command intersect? I mean  exist a union command, but
> I
> don't know if exist a intersect command.
> thanks

Yes.  There is also EXCEPT as well as INTERSECT and UNION.  See the
online docs, in SQL COMMANDS --> SELECT 

-Josh


__AGLIO DATABASE SOLUTIONS___
   Josh Berkus
  Complete information technology  [EMAIL PROTECTED]
   and data management solutions   (415) 565-7293
  for law firms, small businessesfax 621-2533
and non-profit organizations.  San Francisco

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org