| From: | Matt Musgrove <MMusgrove(at)efji(dot)com> | 
|---|---|
| To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> | 
| Cc: | Judy Loomis <JLoomis(at)efji(dot)com> | 
| Subject: | Smallint needs explicit cast in psql? | 
| Date: | 2012-07-16 16:38:43 | 
| Message-ID: | C0FE28B9352B6F4F8CE371643EC3B25121082449@EFJDFWMB01.EFJDFW.local | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-novice | 
Does psql require smallints to be explicitly cast as such? If so then where is this documented? If not then what am I doing wrong? :)
Given the simplest test case I could think of:
CREATE OR REPLACE FUNCTION test_issue(
    parm    smallint
) RETURNS VOID AS $$
BEGIN
    RETURN;
END;
$$ LANGUAGE plpgsql;
nms=# \df test_issue
                           List of functions
Schema |    Name    | Result data type | Argument data types |  Type
--------+------------+------------------+---------------------+--------
public | test_issue | void             | parm smallint       | normal
(1 row)
nms=# select test_issue(1);
ERROR:  function test_issue(integer) does not exist
LINE 1: select test_issue(1);
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
Matthew Musgrove
EF Johnson Technologies, Inc.
Senior Design Engineer
O  972.819.2357
F   972.819.0639
E   mmusgrove(at)efji(dot)com<mailto:mmusgrove(at)efji(dot)com>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-07-16 17:03:50 | Re: Smallint needs explicit cast in psql? | 
| Previous Message | Tom Burns | 2012-07-16 10:30:28 | Fw: Selecting Fields in Union in Subquery |