CREATE FUNCTION Fails with an Insert Statement in it

Поиск
Список
Период
Сортировка
От Jasbinder Singh Bali
Тема CREATE FUNCTION Fails with an Insert Statement in it
Дата
Msg-id a47902760701230851w132a0ae3u21d4b38af7d297ca@mail.gmail.com
обсуждение исходный текст
Ответы Re: CREATE FUNCTION Fails with an Insert Statement in it  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: CREATE FUNCTION Fails with an Insert Statement in it  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Список pgsql-general
I have created the following function :


CREATE OR REPLACE FUNCTION  sp_insert_tbl_l_header(int4,text)
  RETURNS bool AS
$BODY$
INSERT INTO tbl_xyz
(unmask_id,email_from)
VALUES ($1,$2)
$BODY$
  LANGUAGE 'sql' VOLATILE;

when i try to create this fucntion by running this script, i get the
following error:

ERROR:  return type mismatch in function declared to return boolean
DETAIL:  Function's final statement must be a SELECT.
CONTEXT:  SQL function "sp_insert_tbl_xyz"

So i think there is some problem with the return type of the function
when it has an insert statement but really don't know what should be
the return type of this function.

Thanks,
Jas

В списке pgsql-general по дате отправления:

Предыдущее
От: "Michael Schmidt"
Дата:
Сообщение: PostgreSQL 8.2 utilities with Java app on Windows XP
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: CREATE FUNCTION Fails with an Insert Statement in it