Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 5FD12633611 for ; Fri, 19 Mar 2010 11:39:52 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 75006-02 for ; Fri, 19 Mar 2010 14:39:31 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.csc.lt (mail.csc.lt [193.138.191.5]) by mail.postgresql.org (Postfix) with ESMTP id EB0A0632898 for ; Fri, 19 Mar 2010 11:39:40 -0300 (ADT) Received: (qmail 20390 invoked by uid 210); 19 Mar 2010 14:39:37 -0000 Received: from mail.nsoft.lt by mail.csc.lt (envelope-from , uid 201) with qmail-scanner-2.05st (clamdscan: 0.95.3/10595. spamassassin: 3.2.1. perlscan: 2.05st. Clear:RC:1(77.240.249.53):. Processed in 0.01164 secs); 19 Mar 2010 14:39:37 -0000 Received: from mail.nsoft.lt (77.240.249.53) by mail.csc.lt with SMTP; 19 Mar 2010 14:39:37 -0000 Received: from [192.168.16.103] (unknown [77.240.249.53]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (No client certificate requested) by mail.nsoft.lt (Postfix) with ESMTPS id 0B3278E045 for ; Fri, 19 Mar 2010 15:53:46 +0200 (EET) Message-ID: <4BA38CA7.3050606@nsoft.lt> Date: Fri, 19 Mar 2010 16:39:35 +0200 From: Julius Tuskenis Organization: UAB nSoft User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; lt; rv:1.9.1.8) Gecko/20100227 Lightning/1.0b1 Thunderbird/3.0.3 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: insert in function writen in pgplsql References: <4BA37FF5.8060001@nsoft.lt> <4BA38833.60804@lelarge.info> In-Reply-To: <4BA38833.60804@lelarge.info> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.044 tagged_above=-10 required=5 tests=AWL=0.066, BAYES_05=-1.11 X-Spam-Level: X-Archive-Number: 201003/141 X-Sequence-Number: 33940 2010.03.19 16:20, Guillaume Lelarge rašė: > Yes. It would also be easier to debug. > I guess so, but is there no way to tell the postgres that I'm listing the field names and there is no place for a parameter in that list... I tried using INSERT INTO table(table.column .... syntax, but postgres does not accept that. When you write a new function it is not hard to pick the parameter names you want, but when editing it you have to play with what you have and sometimes it's a pain.... One more question Is there a way to use INSERT INTO table($1.... syntax?? I can't think of such case. Can you provide an example? -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050