[SQL] Table constraints and INSERT

Hello I use PostgreSQL in my program and I found a strange behavior, at least for me. I have a simple table with constraint CREATE TABLE "PART" ( "P_PARTKEY" int4 NOT NULL, "P_RETAILPRICE" numeric, CONSTRAINT "PART_PRIMARY" PRIMARY KEY ("P_PARTKEY"), CONSTRAINT "PART_check" CHECK ("P_RET

Re: [SQL] Find min and max values across two columns?

Thank you Tom. Emi Lu <[EMAIL PROTECTED]> writes: ERROR: function greatest(integer, integer) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. We added greatest/least in 8.1, but before that you can just use a CASE