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-09 13:55:05 |
Message-ID: | 373593B9.536B0F2@bigfoot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Simon Drabble wrote:
> I was kinda hoping to do it without resort to (external)
> functions, since I cannot guarantee that Postgres will be the
> target DBMS
Do other SQL databases even have arrays? I kinda assumed that they were
a Postgres thing in any case.
> 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?
Well, that is the assumption I would be working under.
>
> 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(at)foxlink(dot)net
> >
> > --
> > Chris Bitmead
> > http://www.bigfoot.com/~chris.bitmead
> > mailto:chris(dot)bitmead(at)bigfoot(dot)com
> >
> >
>
> --
> "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 | Herouth Maoz | 1999-05-09 14:29:50 | Re: [GENERAL] Selecting from arrays |
Previous Message | Simon Drabble | 1999-05-09 13:48:21 | Re: [GENERAL] Selecting from arrays |