我有一个带有以下字段的表"UserState":
SELECT userid FROM "UserState" WHERE ctime>'2014-07-14'::timestamp
我有一个plpgsql函数,它必须把这个查询的结果作为参数:
get_timeinstate(SELECT userid FROM "UserState" WHERE ctime>'2014-07-14'::timestamp);
如何正确地创建函数以将查询结果作为参数传递到那里?
$func$
BEGIN
RETURN QUERY
SELECT
...myanotherquery...
WHERE "UserState".userid IN (HERE I NEED TO INSERT MY QUERY RESULT)
END;
$func$