Обсуждение: processing of unknown datatype
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
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
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
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
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