return types in functions
От | Brett W. McCoy |
---|---|
Тема | return types in functions |
Дата | |
Msg-id | Pine.BSI.3.91.990303145728.25905E-100000@access1.lan2wan.com обсуждение исходный текст |
Список | pgsql-sql |
I have a function that inserts to columns into a table based upon the result of a query from another table. The problem is, I can't seem to figure out what the proper return type is for this function. Since it doesn't retrieve anything, I can't return anything like that. Here's the function creation statement (without the return type): CREATE FUNCTION insert_unknown_mfr(varchar) RETURNS ?? AS 'INSERT INTO unknown_mfr SELECT DISTINCT manufacturer, drugname FROM drugs WHERE manufacturer = $1' LANGUAGE 'sql; Brett W. McCoy http://www.lan2wan.com/~bmccoy ----------------------------------------------------------------------- Accuracy, n.: The vice of being right ----- BEGIN GEEK CODE BLOCK ----- Version: 3.12 GAT dpu s:-- a C++++ UL++++$ P+ L+++ E W++ N- o K- w--- O@ M-@ !V PS+++ PE Y+ PGP- t++ 5- X+ R+@ tv b+++ DI+++ D+ e>++ h+ r++ y++++ ------ END GEEK CODE BLOCK ------
В списке pgsql-sql по дате отправления: