My problem is that if I write an inline function in postgres, and try to execute in pgscript, I get the "unterminated dollar qouted string" exception:
Code: Select all
do
$tmp$
begin
if not exists(select setting_num from main.system_settings where setting_name='download_rates_mnb') then
insert into main.system_settings(setting_name,setting_num,setting_display) values ('download_rates_mnb',1,'SOAP');
end if;
end
$tmp$
language plpgsql;