Re: problem with my function

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problem with my function
Date: 2002-05-24 20:41:23
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB04C73AD2@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--*sheepishly*

--yeah ... Darren already told me to clean out
my eye sockets regarding that ... i swear i'm going
to set VI to use ispell each and every time
i do stunts like this ...

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]

> drop function t_fastfunc(integer);
> create function t_fastfunc(integer)
> returns interger

Try spelling "integer" correctly.

> psql:./function_cnt.sql:18: NOTICE: ProcedureCreate: return type
'interger'
> is only a shell
> Question: What exactly is it tryiing to tell me about not returning a
value?
> And could someone explain what it means by 'only a shell'?

--ah! now THAT is an explanation!

--thanks folks!

-X

It's trying to warn you that you are getting into deep waters. When you
create a function that's declared to return a previously-unheard-of type
name, the system will take it, on the possibility that you are trying to
create the input function for a type you are about to declare. So
there's an entry made in pg_type ... but it's only a "shell" not a
completed type, and you can't do anything else with it until you declare
the type properly.

regards, tom lane

Browse pgsql-general by date

  From Date Subject
Next Message grant 2002-05-24 22:02:20 Re: Case Insensitive Data Type
Previous Message Tom Lane 2002-05-24 20:21:29 Re: problem with my function