Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.postgresql > #559

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

Path csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!weretis.net!feeder4.news.weretis.net!feeder1.news.weretis.net!wieslauf.sub.de!.POSTED!gonzo.reversiblemaps.ath.cx!not-for-mail
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 10 May 2014 09:53:52 GMT
Organization JJ's own news server
Lines 14
Message-ID <lkksvg$4js$1@gonzo.reversiblemaps.ath.cx> (permalink)
References <lkjb74$4d4$1@wieslauf.sub.de>
NNTP-Posting-Host jQVRSADkPruG0eypnvHqRA.user.wieslauf.sub.de
X-Complaints-To usenet@wieslauf.sub.de
NNTP-Posting-Date Sat, 10 May 2014 10:02:55 +0000 (UTC)
User-Agent slrn/pre1.0.0-18 (Linux)
X-Notice Filtered by postfilter v. 0.8.1
X-Face ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s;a +M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W;(T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6 {T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q;8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^
Cancel-Lock sha1:b3kVRWK+j4ihZFdmDi/lmKxSWd0=
Xref csiph.com comp.databases.postgresql:559

Show key headers only | 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 | NextPrevious 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