BUG #5884: i cant select entire array values
От | yashar ebrahimpoor |
---|---|
Тема | BUG #5884: i cant select entire array values |
Дата | |
Msg-id | 201102141255.p1ECt8VV000272@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #5884: i cant select entire array values
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 5884 Logged by: yashar ebrahimpoor Email address: ebrahimpoor.yashar@gmail.com PostgreSQL version: 8.4.7 Operating system: centos 5.5 Description: i cant select entire array values Details: CREATE TABLE "flight"."FlightList" ( "FlighID" INTEGER DEFAULT nextval('flight.flist_flightid_seq'::regclass) NOT NULL, "FlightDate" DATE[] NOT NULL, "FlightNum" VARCHAR[] NOT NULL, "FlightTime" TIME WITHOUT TIME ZONE[] NOT NULL, "FlightDuration" VARCHAR[] NOT NULL, CONSTRAINT "FlightList_pkey" PRIMARY KEY("FlighID") ) WITH OIDS; after create this table, insert some data INSERT INTO "flight"."FlightList"("FlightDate","FlightNum","FlightTime","FlightDuration" ) VALUES(ARRAY["date"('2011-10-10'),"date"('2011-10-15')], ARRAY['230','231'], ARRAY["time"('21:00:00'),"time"('16:25:00')], ARRAY['2:30','2:35']); now i want to execute this query: select "FlightNum[0]" FROM flight."FlightList"; return this error: ERROR: column "FlightNum[0]" does not exist LINE 1: select "FlightNum[0]" FROM flight."FlightList" please help to resolve this problem. thank you so much.
В списке pgsql-bugs по дате отправления: