Trabla: PostgreSQL & ARRAY: ERROR: syntax error at or near "ANY"
Example:
CREATE TABLE tbl_cars ( id BIGSERIAL PRIMARY KEY, name varchar(200), price double precision );
INSERT INTO tbl_cars(name,price) VALUES('bmw m5', 50000);
INSERT INTO tbl_cars(name,price) VALUES('bmw m6', 60000);
INSERT INTO tbl_cars(name,price) VALUES('toyota land cruiser', 80000);
INSERT INTO tbl_cars(name,price) VALUES('ferrari f430', 250000);
INSERT INTO tbl_cars(name,price) VALUES('mercedes-benz ml 450', 70000);
SELECT name, price
FROM
tbl_cars AS cars
WHERE
cars.name ANY ( ARRAY['bmw m5','mercedes-benz ml 450'] );
Error:
ERROR: syntax error at or near "ANY"
LINE 13: cars.name ANY ( ARRAY['bmw m5','mercedes-benz ml 450'] );
^
********** Error **********
ERROR: syntax error at or near "ANY"
SQL state: 42601
Character: 514
Solving:
use = ANY
SELECT name, price
FROM
tbl_cars AS cars
WHERE
cars.name = ANY ( ARRAY['bmw m5','mercedes-benz ml 450'] );
Result:
name | price
"bmw m5";50000
"mercedes-benz ml 450";70000
No comments:
Post a Comment