How to access a field inside a rowtype in a Postgresql query?

Question

Table FOO has columns A and B

Table BAR has columns X, Y and Z.

I have a function func that returns a ROWTYPE of table BAR

FUNCTION func(arg1, arg2) RETURNS BAR

I want to do something like this

select A,B, func(A,B).X from FOO;

But it fails with the following error:

 syntax error at or near "."

However, if I do not not use .<column_name> after the function, then it serializes the entire RECORD returned by the function as text.

How do I choose just X instead of all constituent fields?

Dojo · Accepted Answer · 2014-10-14 17:43:48Z

3

Found it.

You need to enclose the function call in brackets and then use a .

This fails:

~~select A,B, func(A,B).X from FOO;~~

This works:

select A,B, (func(A,B)).X from FOO;

user330315

answered Oct 14, 2014 at 17:10

Dojo

5,7246 gold badges54 silver badges90 bronze badges

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

1 Comment