Re: insert in function writen in pgplsql - Mailing list pgsql-admin

From Julius Tuskenis
Subject Re: insert in function writen in pgplsql
Date
Msg-id 4BA38CA7.3050606@nsoft.lt
Whole thread Raw
In response to Re: insert in function writen in pgplsql  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: insert in function writen in pgplsql  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: insert in function writen in pgplsql
Next
From: Guillaume Lelarge
Date:
Subject: Re: insert in function writen in pgplsql