From: | Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com> |
---|---|
To: | Postgres Group <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] Selecting from arrays |
Date: | 1999-05-08 23:24:59 |
Message-ID: | 3734C7CB.234B8DE8@bigfoot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
There are some functions in contrib/ that handle some of these cases.
> > > 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(at)foxlink(dot)net
--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:chris(dot)bitmead(at)bigfoot(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Rhoades | 1999-05-09 00:52:48 | unsubscribe |
Previous Message | Simon Drabble | 1999-05-08 19:42:49 | Re: [GENERAL] Selecting from arrays |