Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group