Re: FETCH a cursor inside a SELECT
От | Shridhar Daithankar |
---|---|
Тема | Re: FETCH a cursor inside a SELECT |
Дата | |
Msg-id | 3DE7C5C3.5291.68AB47C@localhost обсуждение исходный текст |
Ответ на | Re: FETCH a cursor inside a SELECT (David Crawshaw <david@zentus.com>) |
Ответы |
Re: FETCH a cursor inside a SELECT
|
Список | pgsql-general |
On 30 Nov 2002 at 0:09, David Crawshaw wrote: > On Sat, 30 Nov 2002 12:00 am, Shridhar Daithankar wrote: > > Not too sure but how about inserting the variable to be passed in a > > single row table and select on that table from view definition? > > Now that's a hairy one! I bet it would work too, but I have multiple > users on this db. :-( I realised that after I shot the answer. Not to sure what I am saying here but how about the join on that view and the single column table? Will that solve your problem? Essentially same as what you have said but just in a different code organisation and that certainly would be readable all along..:-) Bye Shridhar -- Every living thing wants to survive. -- Spock, "The Ultimate Computer", stardate 4731.3
В списке pgsql-general по дате отправления: