Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 542BF2E007C for ; Tue, 4 Dec 2007 08:59:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 17678-07 for ; Tue, 4 Dec 2007 08:59:46 -0400 (AST) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.185]) by postgresql.org (Postfix) with ESMTP id 91F4B2E0077 for ; Tue, 4 Dec 2007 08:59:46 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id f5so2460891nfh for ; Tue, 04 Dec 2007 04:59:44 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=LrflY3Y/htJ9hODTO2z9nnP7U8iSUXrnUaUEZl/Q4+g=; b=WB0L+zyyyKe8hF9iwm0zAuly7ksyQqWnzAUayK4/Tzwk2CS55vwJdJxjSY3JuhBrFlnH0BznAeytvhabFx4apPTNrBYNA7g3p8QJLqCcv589YJdytios4QAGKDRwXru2plyvvNmbgwwjbj6RScrDSb+elDnTSoQkOlpA23Lg38g= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=v+LmFcMgVcmJl7U1B5SK0SMxtko75Yvuqy4dzlh7vaQoybChCMrLk5tuYAz5XByEFkOc5KJd/Ns9CJ+L62Qfbg+O+aiGkfoBBrDI2hQe7nkIMqxDEQFz11OcEMXZuoniQi7KFgJAZ+3QILzwKOIMBpAwoEE1yXhCfbmzPBp65rc= Received: by 10.78.201.2 with SMTP id y2mr3207925huf.1196773183495; Tue, 04 Dec 2007 04:59:43 -0800 (PST) Received: by 10.78.35.7 with HTTP; Tue, 4 Dec 2007 04:59:43 -0800 (PST) Message-ID: <162867790712040459s6ee86399h5dac46cc20d95e9f@mail.gmail.com> Date: Tue, 4 Dec 2007 13:59:43 +0100 From: "Pavel Stehule" To: "Achilleas Mantzios" Subject: Re: Calling functions from within pl/pgsql Cc: pgsql-sql@postgresql.org In-Reply-To: <200712041416.50322.achill@matrix.gatewaynet.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <200712041416.50322.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/5 X-Sequence-Number: 29697 On 04/12/2007, Achilleas Mantzios wrote: > I noticed that in pl/pgsql simply > result := funcname(func,args,...); > just works. > Should i rely on it or take it as a coincidence? :) You found assignment :). Sure, you can use it. http://www.postgresql.org/docs/8.2/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-ASSIGNMENT Regards Pavel Stehule > -- > Achilleas Mantzios > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >