[EMAIL PROTECTED] writes:
> Hello,
>
>I have problem that I can't to call function because postgres
> can't to find this function with specified parameters and I receive
> following error:
>
> Caused by: java.sql.SQLException: ERROR: function
> update_bf_domain(integer, character varying, char
[EMAIL PROTECTED] writes:
> Caused by: java.sql.SQLException: ERROR: function update_bf_domain(integer,
> character varying,
> character varying, timestamp with time
> zone) does not exist
> CREATE OR REPLACE FUNCTION UPDATE_BF_DOMAIN
> (
>
Hello,
I have problem that I can't to call function because postgres can't to find
this function with specified parameters and I receive following error:
Caused by: java.sql.SQLException: ERROR: function update_bf_domain(integer,
character varying,
characte
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Thu, Jun 23, 2005 at 12:36:50AM +0200, Julian Legeny wrote:
>> CREATE OR REPLACE FUNCTION insert_bf_filter(int4, int4, "varchar",
>> "varchar", int4, int2, int2, int4, int2, int4)
> Follow the hint: use explicit type casts for the int2 arguments.
Or
Hello Michael,
yes, you have right. Solution is cast it to smallint.
Thank you for your advice,
with best regards,
Julian Legeny
Thursday, June 23, 2005, 2:48:17 AM, you wrote:
MF> On Thu, Jun 23, 2005 at 12:36:50AM +0200, Julian Legeny wrote:
>>
>> CREATE OR REPLACE FUNCTION inser
On Thu, Jun 23, 2005 at 12:36:50AM +0200, Julian Legeny wrote:
>
> CREATE OR REPLACE FUNCTION insert_bf_filter(int4, int4, "varchar", "varchar",
> int4, int2, int2, int4, int2, int4)
[-snip-]
> select INTGR, TMSTP from INSERT_BF_FILTER (53, 1354, 'test_filter_name',
> 'test_filter_description',
Hello,
I'm using postgres 8.0.3 under win xp. I have problem to call psql function.
I have tables:
1. BF_DOMAIN
2. BF_USER
3. BF_FILTER (this table uses FK from the previous two tables)
and function INSERT_BF_FILTER that inserts data to the table BF_FILTER. But
when I call
