Feed a table function with a query

From: "Robert Wimmer" <seppwimmer(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Feed a table function with a query
Date: 2007-06-01 20:18:19
Message-ID: BAY139-F235ED1CD4A98B7F3D9D08D02C0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Brian Hurt 2007-06-01 20:20:26 Re: How do I insert a record into a table?
Previous Message Michael Glaesemann 2007-06-01 20:00:53 Re: How do I insert a record into a table?