Difference between MySQL and PostgreSQL
I am finding something which I could not understand.
With MySQL tables, I can use LINQPAD to query data easily.
See http://postimg.org/image/5pr2jp4oz/
But with PostgreSQL, it seems weird I can query *., but not with condition,
see below
http://postimg.org/image/jt3k0shp5/ # query Select *. OK
http://postimg.org/image/t1jy896lt/ Not OK
With MySQL tables, I can use LINQPAD to query data easily.
See http://postimg.org/image/5pr2jp4oz/
But with PostgreSQL, it seems weird I can query *., but not with condition,
see below
http://postimg.org/image/jt3k0shp5/ # query Select *. OK
http://postimg.org/image/t1jy896lt/ Not OK
Comments
SELECT * FROM "eMIS" WHERE "SerialNo" = 'WS5000001A'