| From: | David Crawshaw <david(at)zentus(dot)com> |
|---|---|
| To: | shridhar_daithankar(at)persistent(dot)co(dot)in, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: FETCH a cursor inside a SELECT |
| Date: | 2002-11-29 13:51:21 |
| Message-ID: | 200211292351.21162.david@zentus.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 29 Nov 2002 11:42 pm, Shridhar Daithankar wrote:
> How about defining two views? One view that returns matchclass1 and
> another selects on this view to eliminate duplicates.
That would be a nice clean solution, but the functions are a search
system. The integer being passed into the functions is a comparing id
from another table, and then values are compared. As far as I know, a
view is just a static definition.
Reading the archives, I see 7.3 has just come out. Is it considered a
production environment solution? There aren't any references on the
website yet to anything other than 7.2.3.
If so, I could rewrite these functions with SETOF and RETURN NEXT...
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2002-11-29 14:00:03 | Re: FETCH a cursor inside a SELECT |
| Previous Message | Shridhar Daithankar | 2002-11-29 13:42:34 | Re: FETCH a cursor inside a SELECT |