Groups > comp.databases.postgresql > #559

Re: ERROR: query has no destination for result data - What am I doing wrong here?

From	Jasen Betts <jasen@xnet.co.nz>
Newsgroups	comp.databases.postgresql
Subject	Re: ERROR: query has no destination for result data - What am I doing wrong here?
Date	2014-05-10 09:53 +0000
Organization	JJ's own news server
Message-ID	<lkksvg$4js$1@gonzo.reversiblemaps.ath.cx> (permalink)
References	<lkjb74$4d4$1@wieslauf.sub.de>

Show all headers | View raw

On 2014-05-09, Sygma <sygmaprime@sygmacore.com> wrote:
> I'm creating a commodity exchange, basically a place to swap one thing 

> "ERROR:  query has no destination for result data"

> 	INSERT INTO transactions (id,source,symbol,amount,accountid) VALUES 
> (DEFAULT,'ORDERHOLD',sym,amt,acctid) RETURNING id as txid;
> 	return txid;

should be ....  RETURNING id INTO txid;

-- 
umop apisdn

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Find similar

Thread

ERROR:  query has no destination for result data - What am I doing wrong here? Sygma <sygmaprime@sygmacore.com> - 2014-05-09 13:44 -0600
  Re: ERROR:  query has no destination for result data - What am I doing wrong here? Jasen Betts <jasen@xnet.co.nz> - 2014-05-10 09:53 +0000

csiph-web