Thread: processing of unknown datatype

processing of unknown datatype

From
Dave Cramer
Date:
How does the unknown data type get processed, there doesn't seem to be
any casts for it?

I have a function expecting a timestamp, cstring, cstring

if I pass it a timestamp, unknown, unkown it works?
if I pass it an unknown, unknown, unkown, it can't be found?

Dave
-- 
Dave Cramer
519 939 0336
ICQ # 1467551



Re: processing of unknown datatype

From
Tom Lane
Date:
Dave Cramer <pg@fastcrypt.com> writes:
> I have a function expecting a timestamp, cstring, cstring
> if I pass it a timestamp, unknown, unkown it works?
> if I pass it an unknown, unknown, unkown, it can't be found?

You sure it's "can't find it" and not "can't choose among multiple
functions of that name"?
        regards, tom lane


Re: processing of unknown datatype

From
Dave Cramer
Date:
You are correct, it can't choose

Dave
On Tue, 2004-01-06 at 19:47, Tom Lane wrote:
> Dave Cramer <pg@fastcrypt.com> writes:
> > I have a function expecting a timestamp, cstring, cstring
> > if I pass it a timestamp, unknown, unkown it works?
> > if I pass it an unknown, unknown, unkown, it can't be found?
> 
> You sure it's "can't find it" and not "can't choose among multiple
> functions of that name"?
> 
>             regards, tom lane
> 
-- 
Dave Cramer
519 939 0336
ICQ # 1467551



Re: processing of unknown datatype

From
Dave Cramer
Date:
So how can I create a function that it will choose, the option of
casting is not available to me

Dave
On Tue, 2004-01-06 at 19:47, Tom Lane wrote:
> Dave Cramer <pg@fastcrypt.com> writes:
> > I have a function expecting a timestamp, cstring, cstring
> > if I pass it a timestamp, unknown, unkown it works?
> > if I pass it an unknown, unknown, unkown, it can't be found?
> 
> You sure it's "can't find it" and not "can't choose among multiple
> functions of that name"?
> 
>             regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>                http://archives.postgresql.org
> 
-- 
Dave Cramer
519 939 0336
ICQ # 1467551



Re: processing of unknown datatype

From
Tom Lane
Date:
Dave Cramer <pg@fastcrypt.com> writes:
> So how can I create a function that it will choose, the option of
> casting is not available to me

If the inputs are all unknown, I think your only choice is to not have
more than one function of that name (and number of parameters).
Otherwise the system simply doesn't have a basis for making a choice.
        regards, tom lane