2008/8/27 sub3 <[EMAIL PROTECTED]>:
>
> Thanks, I got it to work.
>
> But now I have a different problem.
> If I execute:
> select * from getvss(1, now())
> it works. But instead, if I execute it as:
> select *, getvss(d1.id, now()) from d1
try to
select (getvss(d1.id, now()).* from d1
regards
Thanks, I got it to work.
But now I have a different problem.
If I execute:
select * from getvss(1, now())
it works. But instead, if I execute it as:
select *, getvss(d1.id, now()) from d1
I don't get separate columns for the data coming from getvss, it is all in
one column, unlike the previ
Hello
2008/8/26 sub3 <[EMAIL PROTECTED]>:
>
> Hi,
> I am trying to compress some data down into a single row (making it an
> array). I believe I am close, but I still keep getting an error: "ERROR:
> query has no destination for result data"
>
> Does anyone have an idea what is going wrong? Than
Hi,
I am trying to compress some data down into a single row (making it an
array). I believe I am close, but I still keep getting an error: "ERROR:
query has no destination for result data"
Does anyone have an idea what is going wrong? Thanks.
CREATE or REPLACE FUNCTION getVSS(f_pvid integer,
