SELECT and Arrays

From: Barry Stinson <bas(at)mail(dot)loganfoundation(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: SELECT and Arrays
Date: 2001-03-13 23:08:32
Message-ID: 500_6902_984524912_1@loganfoundation.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<nl>
Hi all -
<nl><nl>

Trying to utilize an array within a table, and to SELECT it using the format [x:y]=something, but cant get it to work...
<nl><nl>

Here is what I'm currently doing (the dumb way):
<nl><nl>

SELECT * FROM students WHERE testscore[1]>70 AND testscore[2]>70;
<nl><nl>

Here is what I'd like to do (the less dumb way;) ):
<nl><nl>

SELECT * FROM students WHERE testscore[1:2]>'{70,70}';
<nl><nl>

--------
<nl><nl>

However, PG keeps complaining about not finding an operator for types '_int4' and 'unknown'.
<nl><nl>

Anyone have any pointers??
<nl><nl>

Thanks,
Barry S

Attachment Content-Type Size
unknown_filename text/richtext 594 bytes

Browse pgsql-general by date

  From Date Subject
Next Message Franck Martin 2001-03-13 23:54:11 RE: Re: Data type for storing images?
Previous Message will trillich 2001-03-13 21:18:19 Re: help with simple rule