From: Guillaume Lelarge <guillaume@lelarge.info>
To: Julius Tuskenis <julius@nsoft.lt>
Cc: pgsql-admin@postgresql.org
Subject: Re: insert in function writen in pgplsql
Date: Fri, 19 Mar 2010 15:48:51 +0100
Message-ID: <4BA38ED3.6070109@lelarge.info> (raw)
In-Reply-To: <4BA38CA7.3050606@nsoft.lt>
References: <4BA37FF5.8060001@nsoft.lt>
<4BA38833.60804@lelarge.info>
<4BA38CA7.3050606@nsoft.lt>
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-...
--
Guillaume.
http://www.postgresqlfr.orghttp://dalibo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: guillaume@lelarge.info, julius@nsoft.lt
Subject: Re: insert in function writen in pgplsql
In-Reply-To: <4BA38ED3.6070109@lelarge.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox