Re: Select + Functions + Composite Types: Behavior - Mailing list pgsql-general

From Tom Lane
Subject Re: Select + Functions + Composite Types: Behavior
Date
Msg-id 25245.1297549950@sss.pgh.pa.us
Whole thread Raw
In response to Select + Functions + Composite Types: Behavior  ("David Johnston" <polobo@yahoo.com>)
Responses Re: Select + Functions + Composite Types: Behavior  ("David Johnston" <polobo@yahoo.com>)
Re: Select + Functions + Composite Types: Behavior  ("David Johnston" <polobo@yahoo.com>)
List pgsql-general
"David Johnston" <polobo@yahoo.com> writes:
> If I put a function that returns a composite type into the FROM clause of a
> SELECT query (and it - the function - is the only source for the query) the
> "*" select list expands so that there is a single record for each component
> of the composite type.

> SELECT * FROM compositereturningfunction()
> Yields -> 2 columns (one for id and one for data)

> I've read quite a bit about plpgsql and composite types and do not recall
> anything about this specific default behavior and methods to force
> (workaround) to the other behavior.

It's just like tables. Try

    select x from compositereturningfunction() x

            regards, tom lane

pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Select + Functions + Composite Types: Behavior
Next
From: "mark"
Date:
Subject: Re: Idle connections