Re: Function not inserting rows

From: rob stone <floriparob(at)gmail(dot)com>
To: Frank Foerster <ivaypoint(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Function not inserting rows
Date: 2017-08-23 16:32:27
Message-ID: 1503505947.5124.5.camel@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

On Wed, 2017-08-23 at 17:23 +0200, Frank Foerster wrote:
>
>
>
> But the created statement looks syntax-wise identical to the pgadmin-
> statement (except for the forced error of course):
>
> select * from api_dev.add_texts_to_item( 444, array['PGADM1',
> 'PGADM2'] );
>
>
>

I don't use python but the traditional way to call a function is:-

select api_dev.add_texts_to_item( 444, array['PGADM1','PGADM2'] );

HTH,
Rob

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2017-08-23 18:40:06 Re: PG and database encryption
Previous Message ivay 2017-08-23 16:27:49 Re: Function not inserting rows