SCM

[#1010791] Npgsql returns error for this procedure

View Trackers | Support Requests | Download .csv | Monitor

Date:
2010-04-20 10:57
Priority:
3
State:
Open
Submitted by:
Oleg Cherkasenko (win32nipuh)
Assigned to:
Nobody (None)
Category:
Group:
Resolution:
None
 
Summary:
Npgsql returns error for this procedure

Detailed description
Hello all,

I discovered this kind of problem

When I use procedure which has at least one input parameter and returns table then I receive error:

42601 SYNTAX ERROR near )

When I remove input parameter for experiment - it works
When I left input parameter but replace RETURNS TABLE with RETURNS SETOF mytype - it works too.

This is my procedure

CREATE OR REPLACE FUNCTION getids_test
(
parentid UUID
)
RETURNS TABLE
( node_id UUID,
"node_type" INTEGER,
"node_order" INTEGER,
"node_name" VARCHAR,
node_sub_type INTEGER
)
AS
$$
DECLARE nodetype INTEGER:=2;
BEGIN

RETURN QUERY
SELECT id, "type",0 , ''::VARCHAR,sub_type FROM vs WHERE parent_id = parentid;

RETURN;
END
$$
LANGUAGE plpgsql;

Followup

No Followups Have Been Posted

Attached Files:

Changes:

No Changes Have Been Made to This Item

Powered By FusionForge