postgres 过程在 »end« 附近出现语法错误

发布于 2025-01-11 13:16:13 字数 532 浏览 0 评论 0原文

当我尝试运行我的 prorudere 时遇到问题。我有一个表，其中所有值都以文本格式存储，并尝试转换为 int 或时间戳

CREATE OR REPLACE PROCEDURE public.textnummerictest(
)
LANGUAGE 'sql'
AS $BODY$
create or replace procedure textnummerictest()
language plpgsql
as $$
begin
 insert into sensorhistory_test(
  datetime,
  sensorid     )
 select from sensorhistory_temp (
  cast(sensorid as integer),
  datetime::timestamp       )
 end; $$
$BODY$;

ALTER PROCEDURE public.textnummerictest()
OWNER TO postgres;

总是在接近结束时出现错误 Syntaxerror。

任何帮助真的很感激

原文

I am facing an issue when I try to run my procudere. I have a table where I have all values stored in text format and try to convert to int or timestamp

CREATE OR REPLACE PROCEDURE public.textnummerictest(
)
LANGUAGE 'sql'
AS $BODY$
create or replace procedure textnummerictest()
language plpgsql
as $
begin
 insert into sensorhistory_test(
  datetime,
  sensorid     )
 select from sensorhistory_temp (
  cast(sensorid as integer),
  datetime::timestamp       )
 end; $
$BODY$;

ALTER PROCEDURE public.textnummerictest()
OWNER TO postgres;

Always getting the error Syntaxerror near end.

Any help really appreciated

分享到QQ

分享到微博