PostGreSQL tutorial

[Seldom]

Code Select Expand

UPDATE area SET mp_type = '0x46' WHERE WHERE (fcode = 46000 or fcode = 46006) and areasqkm >= 15;
UPDATE area SET mp_type = '0x47' WHERE WHERE (fcode = 46000 or fcode = 46006) and areasqkm >= 10 and areasqkm < 15;
UPDATE area SET mp_type = '0x48' WHERE WHERE (fcode = 46000 or fcode = 46006) and areasqkm >= 2 and areasqkm < 10;

This query segment is lifted from the Hydrography tutorial.  Are the two "WHERE"s a typo, or do you need them when you have the "or" statement in parentheses next to an "and"?

[-Oz-]

That is a typo.  Two wheres will not work.

[-Oz-]

Fixed.  Thanks

[Seldom]

Thank you, OZ!