Problem with array - Mailing list pgsql-sql

From Bernie Huang
Subject Problem with array
Date
Msg-id 393BF0F8.64EA1CE1@ec.gc.ca
Whole thread Raw
List pgsql-sql
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

Attachment

pgsql-sql by date:

Previous
From: "Rob S."
Date:
Subject: RE: Default timestamp value
Next
From: Fabrice Scemama
Date:
Subject: Re: Vacuum problem in my system ?