plpgsql function Syntax
| От | derrick@grifflink.com |
|---|---|
| Тема | plpgsql function Syntax |
| Дата | |
| Msg-id | 00dd01c4908a$6f1dff60$0200a8c0@main обсуждение исходный текст |
| Ответы |
Re: plpgsql function Syntax
|
| Список | pgsql-novice |
Is it possible to get a select statement to work like this with a for loop?
CREATE FUNCTION public.search(int4)
RETURNS SETOF search1 AS
'
DECLARE
category alias for $1;
newrows search1%rowtype;
rec RECORD;
SQLCommand varchar;
BEGIN
IF (category = 0) THEN
SQLCommand := 'SELECT * FROM table';
ELSE
SQLCommand := 'SELECT idnumber FROM table';
END IF;
FOR rec IN SQLCommand
LOOP
...blah...
...blah...
END LOOP;
Basically I want to create the SELECT statement dynamically and then use
that select statement in subsequent querries later in the function. Will
this syntax work or should I try to use a VIEW?
Thanks,
Derrick
В списке pgsql-novice по дате отправления: