Message-ID: <4BA38ED3.6070109@lelarge.info>
Date: Fri, 19 Mar 2010 15:48:51 +0100
From: Guillaume Lelarge <guillaume@lelarge.info>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; fr;
	rv:1.9.1.8) Gecko/20100227 Thunderbird/3.0.3
MIME-Version: 1.0
To: Julius Tuskenis <julius@nsoft.lt>
CC: pgsql-admin@postgresql.org
Subject: Re: insert in function writen in pgplsql
References: <4BA37FF5.8060001@nsoft.lt> <4BA38833.60804@lelarge.info>
	<4BA38CA7.3050606@nsoft.lt>
In-Reply-To: <4BA38CA7.3050606@nsoft.lt>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Le 19/03/2010 15:39, Julius Tuskenis a écrit :
> 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.

No, there's no way.

> 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....
> 

I always add prefix to work around this (p_user for example).

> 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?
> 

You'll find examples and explanations in the fine manual:


http://www.postgresql.org/docs/8.4/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN


-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com