| From: | Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca> |
|---|---|
| To: | PGSQL-SQL <pgsql-sql(at)postgresql(dot)org> |
| Cc: | PHP-PGSQL <php-pgsql(at)linuxports(dot)com> |
| Subject: | Problem with array |
| Date: | 2000-06-05 18:27:04 |
| Message-ID: | 393BF0F8.64EA1CE1@ec.gc.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| bernie.huang.vcf | text/x-vcard | 315 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fork | 2000-06-05 18:58:42 | |
| Previous Message | Fabrice Scemama | 2000-06-05 17:43:38 | Vacuum problem in my system ? |