Re: [GENERAL] PSQL Function() help....
От | Peter Eisentraut |
---|---|
Тема | Re: [GENERAL] PSQL Function() help.... |
Дата | |
Msg-id | Pine.LNX.4.21.0001151954070.386-100000@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: [GENERAL] PSQL Function() help.... ("omid omoomi" <oomoomi@hotmail.com>) |
Список | pgsql-general |
An array is not quite the same as a result set. What the questioner wanted (as I understand it) was a function that returned more than one row. That doesn't work. If you manage to do it via arrays, more power to you. On 2000-01-13, omid omoomi mentioned: > Hello, > Sure you can use arrays as returned results in your function. > > regards. > Omid Omoomi > > > >From: Peter Eisentraut <peter_e@gmx.net> > >To: Dale Anderson <danderso@crystalsugar.com> > >CC: pgsql-general@postgresql.org > >Subject: Re: [GENERAL] PSQL Function() help.... > >Date: Wed, 12 Jan 2000 04:58:53 +0100 > > > >On 2000-01-12, Dale Anderson mentioned: > > > > > Here is what I am trying to do. I an trying to create a function > > > that is passed two numbers, get_people(2000,1). The first value is a > > > year, and the second is a week. What I want the function to do, is to > > > select all the names from a name table, and return a list of names > > > that don't have an entry in the data table for the year, and week > > > specified. Can this be done?? > > > >No. Functions cannot return result sets. Certainly a deficiency, but > >nobody is perfect. > > > > > >-- > >Peter Eisentraut Sernanders väg 10:115 > >peter_e@gmx.net 75262 Uppsala > >http://yi.org/peter-e/ Sweden > > > > > > > >************ > > > > > -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden
В списке pgsql-general по дате отправления: