Dynamic SQL, Return Query Execute with Join - Mailing list pgsql-general

From Mark Watson
Subject Dynamic SQL, Return Query Execute with Join
Date
Msg-id F83BB77205FD4D329979E87426C8989F@Gateway
Whole thread Raw
List pgsql-general
Hi all,
I wish to pass a query text (containing joins) and separate parameters to a
plpgsql function that will return a result set (more than one row) using
RETURN QUERY EEXECUTE, but am having trouble defining the result set because
of the join. Am I limited to the result set being restricted to one table
definition and will need to use a view instead? Sorry if my question is too
concise - I can provide sample code if necessary.

Postgres 8.4.2 on Windows.

Mark Watson


pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: How to escape apostrophes when apostrophes already used to escape something else
Next
From: manugarciac
Date:
Subject: Idle in Transaction