From: | "Andreas Junius" <andreas(at)junius(dot)info> |
---|---|
To: | "Andreas Kretschmer" <akretschmer(at)spamfence(dot)net> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: SQL Status:42883 |
Date: | 2008-12-02 07:12:15 |
Message-ID: | 1492952056.20081202081215@junius.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Oh my god! I have found my mistake. I used now() as an argument, which
is a 'timestamp with time zone' type, but my method expects 'timestamp
without time zone'. It's a minor difference, but is one. I'm surprised,
that this didn't happen earlier.
Andreas
am Montag, 1. Dezember 2008 um 20:18 schrieben Sie:
AK> Andreas Junius <andreas(at)junius(dot)info> schrieb:
>> Hi Postgres professionals,
>>
>> I hope someone is able to give some advice to the following matter:
>>
>> I created two plpgsql functions, which appear in pgAdminIII as
>> expected. The first one works fine, it has only four arguments. The
>> other one has 10 arguments and I have got the error
>>
>> FEHLER: Funktion md.insertuser(unknown, unknown, unknown, integer, unknown, unknown, unknown, unknown, integer, timestamp with time zone) existiert nicht
>> SQL Status:42883
>> Hinweis:Keine Funktion stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen.
>> Zeichen:15
From | Date | Subject | |
---|---|---|---|
Next Message | Ognjen Blagojevic | 2008-12-02 14:42:32 | Re: Mailing list problem: TLD .rs not recognized as valid |
Previous Message | Mark Roberts | 2008-12-01 23:00:07 | Re: unsure of how to query for desired data/output |