Re: [HACKERS] Fwd: Weird issues when reading UDT from stored function

> Here, we've somehow got the first two fields of u_address_type - street and

> zip - squashed together into one column named 'street', and all the other

> columns nulled out.

 

I think this is the old problem of PL/pgsql having two forms of SELECT

INTO.  You can either say:

 

SELECT col1, col2, col3, ... INTO recordvar FROM ...

 

Or you can say:

 

SELECT col1, col2, col3, ... INTO nonrecordvar1, nonrecordvar2,

nonrecordvar3, ... FROM ...

 

In this case, since address is a recordvar, it's expecting the first

form - thus the first select-list item gets matched to the first

column of the address, rather than to address as a whole.  It's not

smart enough to consider the types of the items involved - only

whether they are records.  :-(