Re: [GENERAL] Selecting from arrays

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