[SQL] What is wrong?
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 pgsqlselect 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!
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