Re: Passing result of multirow subquery to C function - Mailing list pgsql-novice

From David Johnston
Subject Re: Passing result of multirow subquery to C function
Date
Msg-id 1388507049253-5784915.post@n5.nabble.com
Whole thread Raw
In response to Passing result of multirow subquery to C function  (Magnus Persson <magnus.e.persson@gmail.com>)
Responses Re: Passing result of multirow subquery to C function  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-novice
Select hello(name) from names

You can only pass a single row to a function.  A work around is to use
arrays but for your example the above form is what you would do and is
typical of function usage in a table context.

David J.



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Passing-result-of-multirow-subquery-to-C-function-tp5784914p5784915.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.


pgsql-novice by date:

Previous
From: Magnus Persson
Date:
Subject: Passing result of multirow subquery to C function
Next
From: Tom Lane
Date:
Subject: Re: Passing result of multirow subquery to C function