Database function syntax for inserting records

Поиск
Список
Период
Сортировка
От Susan Hoddinott
Тема Database function syntax for inserting records
Дата
Msg-id 000901c2e1e5$cd7ee100$1f84fea9@oemcomputer
обсуждение исходный текст
Ответы Re: Database function syntax for inserting records  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-sql
Hello,
 
I have created the following function:
 

CREATE OR REPLACE FUNCTION orderinsert(INTEGER, VARCHAR) RETURNS INTEGER AS '

INSERT INTO HEXORDERS ( CUSTOMER_ID, ORDER_KEY, DISTRIBUTOR_ID, ORDER_AMOUNT, ORDER_GST )

VALUES ( $1, $2, 1, 0, 0 ) ;

SELECT 1 ;

' LANGUAGE SQL ;

 

which seems to me to be consistent with the instructions given in the Reference manual.  However, when trying to create this function I receive the errors:

parser: parse error at or near ";"

parser: parse error at or near "orderinsert"

Can any one tell my what I am doing wrong as this seems to be exactly as specified in the Reference and Programmer manuals?

 

Regards

 

Вложения

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

Предыдущее
От: Matthew Metnetsky
Дата:
Сообщение: Re: HardCORE QUERY HELP!!!
Следующее
От: Erwin Moller
Дата:
Сообщение: Re: HardCORE QUERY HELP!!!