On Apr 17, 11:19 am, Ketema <[EMAIL PROTECTED]> wrote:
> On Apr 17, 7:35 am, Ketema <[EMAIL PROTECTED]> wrote:
>
>
>
> > On Apr 16, 6:24 pm, [EMAIL PROTECTED] (Tom Lane) wrote:
>
> > > "Ketema" <[EMAIL PROTECTED]> writes:
> > > > I have an example were I have to build a string in the below manner:
On Apr 17, 7:35 am, Ketema <[EMAIL PROTECTED]> wrote:
> On Apr 16, 6:24 pm, [EMAIL PROTECTED] (Tom Lane) wrote:
>
>
>
> > "Ketema" <[EMAIL PROTECTED]> writes:
> > > I have an example were I have to build a string in the below manner:
> > > values (' || new.tpv_success_id || ',''' || new.order_date
On Apr 16, 6:24 pm, [EMAIL PROTECTED] (Tom Lane) wrote:
> "Ketema" <[EMAIL PROTECTED]> writes:
> > I have an example were I have to build a string in the below manner:
> > values (' || new.tpv_success_id || ',''' || new.order_date || ''',' ||
> > new.tpv_id || ',' || new.ver_code || ',''' || new.ag
"Ketema" <[EMAIL PROTECTED]> writes:
> I have an example were I have to build a string in the below manner:
> values (' || new.tpv_success_id || ',''' || new.order_date || ''',' ||
> new.tpv_id || ',' || new.ver_code || ',''' || new.agent_name || ''','
> || new.agent_id || ','
> || n
On Apr 16, 4:47 pm, [EMAIL PROTECTED] (Martijn van Oosterhout) wrote:
> On Mon, Apr 16, 2007 at 01:37:43PM -0700, Ketema wrote:
> > create or replace function schema.insert_function(_schema text, _table
> > text) returns integer
>
>
>
> >set search_path to _schema;
> >insert into _table (c
On Mon, Apr 16, 2007 at 01:37:43PM -0700, Ketema wrote:
> create or replace function schema.insert_function(_schema text, _table
> text) returns integer
> set search_path to _schema;
> insert into _table (columns) values(vals);
> is there any whay to get the functionality of above
create or replace function schema.insert_function(_schema text, _table
text) returns integer
as
$BODY$
declare
_affected integer;
begin
set search_path to _schema;
insert into _table (columns) values(vals);
return 0;
end;
$BODY$ language plpgsql;
is there any whay to get th
