Re: Functions returns to libpq with wrong column split

From: Andy Halsall <halsall_andy(at)hotmail(dot)com>
To: <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "postgresql (dot)org novice list" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Functions returns to libpq with wrong column split
Date: 2011-10-19 08:45:38
Message-ID: BLU123-W21822DF8C236F91C01BB7EF5EA0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


That's fixed it. Many thanks Tom.

> > "SELECT readnode4($1)",
>
> I think you probably want "SELECT * FROM readnode4($1)". As-is,
> you're getting a single composite-type column from the SELECT.
>
> regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Rikard 2011-10-20 00:24:42 Can triggers update other tables?
Previous Message Tom Lane 2011-10-18 23:45:48 Re: Functions returns to libpq with wrong column split