[SQL] Problem with array

[Bernie Huang]

Hi,

Instead of using
    select car_name
    from car_table
    where car_property[1]='1995';   (*)

Can I use
    where car_property['year']='1995';

in Postgres??  I want to use a more descriptive name than just using
index for the array (not just during insertion but as well as to specify
it in table creation!)

Any idea?  Thanks.


- Bernie

begin:vcard 
n:Huang;Bernie
tel;fax:(604)664-9195
tel;work:(604)664-9172
x-mozilla-html:TRUE
org:Environment Canada;Standards and Technology Services
adr:;;700-1200 West 73 Ave.;Vancouver;BC;V6P 6H9;Canada
version:2.1
email;internet:[EMAIL PROTECTED]
title:Programmer
x-mozilla-cpt:;0
fn:Bernie Huang
end:vcard