Re: Array OUT columns in a record returned from a function - Mailing list pgsql-general

Ged <pgsql4gm@gmail.com> writes:
> SELECT
>     q.id, q.name, q.summary, q.instructions, q.experience, q.notes,
> q.starts, q.ends
> ,    q.stage, st.description
> ,    q.series, r.name
> ,    COALESCE('../zones/' || q.zone, '../instances/' || q.instance)
> ,    COALESCE(z.name, i.name)
> INTO
>     results.id
> ,    results.name
> ,       results.summary
> ,       results.instructions
> ,       results.experience
> ,       results.notes
> ,    results.starts[0]
> ,       results.ends
> ,       results.stage
> ,       results.warning
> ,       results.series
> ,       results.series_name
> ,       results.location
> ,       results.location_name
> FROM

I don't think an INTO target can be anything except a simple variable or
simple record field.  So the [0] is taken as part of the SQL query
rather than part of an INTO target, and it goes downhill from there.

Consider assigning that value to a temp variable and then assigning
into the desired result format.

            regards, tom lane