Im trying to create a store procedure at module install by

__openerp_.py:

 ...

   'data': [

"data/activity_period_team_sp.sql",

...

and on data/activity_period_team_sp.sql file:

create or replace function select_activity_by_period_team(from_date date, to_date date,team_id int)

RETURNS TABLE(

id int,

name varchar,

full_date date,

semana float8,

fecha text,

descripcion text,

iniciativas bigint,

oportunidades bigint,

llamadas bigint,

cotizaciones bigint,

montos numeric

)

LANGUAGE sql AS

$$

SELECT u.id,

p.name,

dats.date as full_date,

...

So the log error says:

 File "/home/carlos/odoo8/source/odoo/openerp/sql_db.py", line 234, in execute

res = self._obj.execute(query, params)

ProgrammingError: unterminated dollar-quoted string at or near "$$ ...

If i run my sql statement on psql it works but if i try to doit by odoo dont

Some one has succeed on this?