Feed a table function with a query - Mailing list pgsql-novice

From Robert Wimmer
Subject Feed a table function with a query
Date
Msg-id BAY139-F235ED1CD4A98B7F3D9D08D02C0@phx.gbl
Whole thread Raw
Responses Re: Feed a table function with a query  (Derrick Betts <list@blueaxis.com>)
List pgsql-novice
Hi,

is there any possibility to feed a "table" function with a query. foe
example

CREATE FUNCTION func(id INT) RETURNS SETOF tmp AS ...

SELECT * FROM func(<scalar>); works as expected

What i want to do is something like

SELECT * FROM func((SELECT id FROM pers WHERE name ILIKE 'w%'));

i am using 8.0 on windows

regards sepp

_________________________________________________________________
Ein gigantisches Konzert kämpft gegen eine fortschreitende Klimakrise.
http://liveearthsos.msn.com/Hub.aspx?mkt=de-at


pgsql-novice by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: How do I insert a record into a table?
Next
From: Brian Hurt
Date:
Subject: Re: How do I insert a record into a table?