FAQ
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

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 2 | next ›
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedJun 1, '07 at 8:18p
activeJun 1, '07 at 8:31p
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Robert Wimmer: 1 post Derrick Betts: 1 post

People

Translate

site design / logo © 2022 Grokbase