From: Julius Tuskenis <julius@nsoft.lt>
To: pgsql-admin@postgresql.org
Subject: Re: insert in function writen in pgplsql
Date: Fri, 19 Mar 2010 16:39:35 +0200
Message-ID: <4BA38CA7.3050606@nsoft.lt> (raw)
In-Reply-To: <4BA38833.60804@lelarge.info>
References: <4BA37FF5.8060001@nsoft.lt>
<4BA38833.60804@lelarge.info>
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
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: julius@nsoft.lt
Subject: Re: insert in function writen in pgplsql
In-Reply-To: <4BA38CA7.3050606@nsoft.lt>
* 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