Postgres Pro
Downloads
Home   >   mailing lists

Pg/SQL returning composite type - Mailing list pgsql-general

From P. Broennimann
Subject Pg/SQL returning composite type
Date
Msg-id CACm4aU8hkp5c8_Y+oq4BWxgDdZGcLPihi2UfG3K0je=PWBkCxg@mail.gmail.com
Whole thread Raw
Responses Re: Pg/SQL returning composite type  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Tree view
Hi there

I have in schema "core":

   CREATE OR REPLACE FUNCTION core.f_read
   (
     ...
   )
   RETURNS core.c_result_type AS
   $$
   declare
     c_result core.c_result_type%rowtype;
   begin
     ...
     return c_result;  
   end
   ...

   CREATE TYPE core.c_result_type AS (
     a_value        text,
     a_result_code  integer,
     a_result       text,
     a_time         integer
   );

And in schema "canu":

   CREATE OR REPLACE FUNCTION canu.f_read
   (
     ...
   )
   RETURNS canu.c_result_type AS
   $$
   declare
     c_result canu.c_result_type%rowtype;
   begin
     select core.f_read(...) into c_result; 
     return c_result;  
   end
   ...

   CREATE TYPE canu.c_result_type AS (
     a_value        text,
     a_result_code  integer,
     a_result       text,
     a_time         integer
   );

When calling core.f_read() the result is fine. When calling canu.f_read() I get all values back together/concatenated in the first "a_value" field!?

What am I doing wrong here? I am using PG 9.1.6 under Ubuntu 10.04/64

Thanks & cheers,
Peter

pgsql-general by date:

Previous
From: Sébastien Lardière
Date:
Subject: Re: Plproxy with returns table() make PG segfault
Next
From: Raymond O'Donnell
Date:
Subject: Re: Pg/SQL returning composite type