-
Error - SQL state: 22P02
I am executing
select * from "Booking" where 'Booking_Id' = 10;
-- where column 'Booking_Id' is type numeric
I get a error
ERROR: invalid input syntax for integer: "Booking_Id"
********** Error **********
ERROR: invalid input syntax for integer: "Booking_Id"
SQL state: 22P02
What could be the reason?
-
You wrote :
select * from "Booking" where 'Booking_Id' = 10;
you should have wroten:
select * from "Booking" where Booking_Id = 10;
or as well
select * from "Booking" where "Booking_Id" = 10;
hope it helps.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|