Returning values from a PostgreSQL function

Question

I have a function that loop a table and do processing returning values. I was returning SETOF VARCHAR[] and returning with RETURN NEXT the_varchar_array and worked fine.

But now I need to return some INTEGER before the VARCHAR[].

How I can define the returning value to return the INTEGER value and the VARCHAR[] and how I returning they inside the function?

If a define as RETURNS SETOF INTEGER, INTEGER, INTERGER, VARCHAR[], it don't works.

If I use RETURNS TABLE(a INTEGER, b INTEGER, c INTEGER, d VARCHAR[]), works, but I don't know how to return each value inside the function.

RETURN NEXT a,b,c,d doesn't works. Only RETURN NEXT return an empty line.

This development documentation at PostgreSQL shows the different ways to return values from functions. You might have to look into a composite return type or a row of data containing all of your values. — Cᴏʀʏ
– Cᴏʀʏ, Commented Dec 1, 2011 at 17:26
@Cory I used a composite type and solved my problem. Please, answer this question to select your answer. — Renato Dinhani
– Renato Dinhani, Commented Dec 1, 2011 at 18:04

Cᴏʀʏ · Accepted Answer · 2011-12-01 19:27:39Z

2

This development documentation at PostgreSQL shows the different ways to return values from functions. You might have to look into a composite return type or a row of data containing all of your values.

Note - comment converted to an answer at the OP's request

answered Dec 1, 2011 at 19:27

Cᴏʀʏ

108k20 gold badges169 silver badges201 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mike Christensen · Accepted Answer · 2011-12-01 17:26:13Z

1

Try:

RETURNS SETOF record

That should allow you to return any information you want.

answered Dec 1, 2011 at 17:26

Mike Christensen

91.8k52 gold badges223 silver badges349 bronze badges

Collectives™ on Stack Overflow

Returning values from a PostgreSQL function

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related