Thread: Problem with array

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