Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA40267; Sat, 8 May 1999 10:50:36 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id KAA18890; Sat, 8 May 1999 10:49:18 -0400 (EDT) To: Carlos Peralta Ramirez cc: pgsql-novice , pgsql-sql , pgsql-general Subject: Re: [SQL] Functions for arrays !!!! In-reply-to: Your message of Fri, 07 May 1999 09:56:44 -0500 <3732FF2A.94199716@hera.inf.ucv.cl> Date: Sat, 08 May 1999 10:49:18 -0400 Message-ID: <18888.926174958@sss.pgh.pa.us> From: Tom Lane Carlos Peralta Ramirez writes: > I create the function in PostgreSQL -> > dbtest=>create function tester(_int4,int4) returns bool as > '$path/tester.so' language 'c'; > CREATE > But when try to use it, -> > dbtest=>select tester('{1,2,3,4}',3); > ERROR: stat failed on file tester.so > I donīt know whatīs happens !!!!! Looks like Postgres couldn't find the .so file to load it. (The error message is sadly incomplete --- maybe I'll look to see if it can be improved.) When you wrote '$path/tester.so' above, were you being literal or did you mean to indicate that you filled in an appropriate path? All the examples you might see of that notation in Postgres are in shell scripts where a variable like $path will get expanded; if you typed it in by hand then you have to supply the complete path by hand. Look at the entry for the tester function in the pg_proc table to see what pathname the system has recorded... regards, tom lane