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:
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___