On 06/03/17 11:36, Günce Kaya wrote:
> Hi all,
>
> I created a dummy table and related function that include insert script.
> When I execute the function I'm getting error like bellow;
>
> ERROR: function cargo.insertinvoice(integer, integer, integer,
> *unknown, unknown, unknown*, integer, timestamp with time zone, integer,
> integer, money, timestamp with time zone, timestamp with time zone,
> timestamp with time zone) does not exist
>
> LINE 1: select * from cargo.insertinvoice(1013, 10, 44, 'asda','test...
>
> ^
>
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
>
>
> Table's create script as bellow;
>
> CREATE TABLE cargo.invoice
> (
> id bigserial NOT NULL,
> orderid integer NOT NULL,
> cargoid integer NOT NULL,
> invoiceowner integer NOT NULL,
> invoiceaddress character(250) NOT NULL,
> receiverfname character varying(50) NOT NULL,
> receiverlname character varying(50) NOT NULL,
> receiverphone integer NOT NULL,
> sendingdatetime timestamp without time zone DEFAULT now(),
> distance real NOT NULL,
> weight numeric NOT NULL,
> addedtax numeric NOT NULL DEFAULT 8,
> invoiceamount money DEFAULT 0,
> cargocreateddate date,
> cargoupdateddate timestamp without time zone,
> cargocancelled timestamp without time zone);
>
> The function that content insert script to cargo.invoice table is following;
>
> create or replace function cargo.insertinvoice (forderid integer,
> fcargoid integer, finvoiceowner integer, finvoiceaddress character,
> freceiverfname character varying, freceiverlname character varying,
> freceiverphone integer, fsendingdatetime timestamp without time zone,
> fdistance real, fweight numeric, finvoiceamount money,
> fcargocreateddate date, fcargoupdateddate timestamp, fcargocancelled
> timestamp without time zone) returns numeric as $$
>
> declare v_id bigint;
>
> begin
>
> insert into cargo.invoice (orderid, cargoid, invoiceowner,
> invoiceaddress, receiverfname, receiverlname, receiverphone,
> sendingdatetime, distance, weight, addedtax, invoiceamount,
> cargocreateddate, cargoupdateddate, cargocancelled)
> values(forded, fcargoid, finvoiceowner, finvoiceaddress,
> freceiverfname,freceiverlname,freceiverphone, fsendingdatetime,
> fdistance, fweight, faddedtax, finvoiceamount, fcargocreateddate,
> fcargoupdateddate, fcargocancelled);
>
> select max(id) into v_id from cargo.invoice;
>
> return v_id;
>
> end;
>
> $$ language plpgsql;
>
>
> So, when I execute the function like;
>
> select * from cargo.insertinvoice(1013, 10, 44, 'asda','test1','test2',
> 12345, now(), 10000,30, 400, now(), now(), now());
You've declared the function with type "character" for the fourth
parameter, but you're trying to pass a varchar or text value.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie