Re: [GENERAL] Selecting from arrays
От | Simon Drabble |
---|---|
Тема | Re: [GENERAL] Selecting from arrays |
Дата | |
Msg-id | Pine.LNX.3.96.990509094354.22324C-100000@dragon обсуждение исходный текст |
Ответ на | Re: [GENERAL] Selecting from arrays (Chris Bitmead <chris.bitmead@bigfoot.com>) |
Список | pgsql-general |
On Sat, 8 May 1999, Chris Bitmead wrote: > > There are some functions in contrib/ that handle some of these cases. Thanks for the pointer. I was kinda hoping to do it without resort to (external) functions, since I cannot guarantee that Postgres will be the target DBMS and I also cannot get array_iterator to compile :( On the subject of contribs, what sort of licence are these distributed under? I can't find any documentation for them except for the main COPYRIGHT file in the top-level postgres directory. Does this mean the contribs are covered by the same terms, so I can distribute the array_iterator code with my app provided I include the copyright notice? Simon. > > > > > date loc temperature (int4[]) > > > > 12/01/98 4th & Main {12, 14, 14, 15, 17, 19, 25, ...} > > > > 12/04/98 Station 4 {12, 13, 14, 666, 18, 20, 24, ...} > > > > > > > > I want to select only those rows where one of the recorded temps is equal to , > > > > say, 17 , and also to select a range (rows where temp > 20, or where temp < > > > > 10). I might also want to select rows where the temp could not be measured > > > > (indicated by 666) at a certain period. > > > > > > > > > > How you can do it ???? > > > You create a function or ..???? > > > You can send me some example, please ???? > > > I try to make a function, for manegement the arrays , Me right ? > > > > > > > > > > > I'd rather not have to code a function for something which, it seems to > > me, should be part of the installation. The application is eventually > > intended for several platforms all of which might be running different > > DBMS's, so I'd like to know if there's a common SQL way to do this and if > > so if Postgres supports it. > > > > Simon. > > > > -- > > "When a German dwarf dances with the butcher's son.." -- Tom Waits > > > > Simon Drabble Somewhere in cyberspace > > simond@foxlink.net > > -- > Chris Bitmead > http://www.bigfoot.com/~chris.bitmead > mailto:chris.bitmead@bigfoot.com > > -- "When a German dwarf dances with the butcher's son.." -- Tom Waits Simon Drabble Somewhere in cyberspace simond@foxlink.net
В списке pgsql-general по дате отправления: