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 insert_bf_filter(int4, int4, "varchar",
>> "varchar", int4, int2, int2, int4, int2, int4)
MF> [-snip-]
>> select INTGR, TMSTP from INSERT_BF_FILTER (53, 1354, 'test_filter_name',
>> 'test_filter_description', 1, 0, 0, 10, 0, 100)
>>
>> And it returns me following error:
>> ERROR: function insert_bf_filter(integer, integer, "unknown", "unknown",
>> integer, integer, integer, integer, integer, integer) does not exist
>> HINT: No function matches the given name and argument types. You may need to add explicit type casts.
MF> Follow the hint: use explicit type casts for the int2 arguments. Try this:
MF> select INTGR, TMSTP
MF> from INSERT_BF_FILTER(53, 1354, 'test_filter_name', 'test_filter_description',
MF> 1, 0::int2, 0::int2, 10, 0::int2, 100);
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
