Re: Select record by ID

# ceo@l-i-e.com / 2007-01-29 17:54:03 -0600: > MySQL is the *only* db engine that lets you get away with [bleep] like > apostrophes around numbers. Actually, these are examples of valid SQL: INTEGER '1', FLOAT '13.5'. test=# select version(); version ------------------------------------------------------------------------------------------------- PostgreSQL 8.1.3 on amd64-portbld-freebsd6.1, compiled by GCC cc (GCC) 3.4.4 [FreeBSD] 20050518 (1 row) test=# select '13.5' * '30'; ERROR: operator is not unique: "unknown" * "unknown" test=# select float '13.5' * integer '10'; ?column? ---------- 135 (1 row) test=# create table t (f float, i integer); CREATE TABLE test=# insert into t values ('13.5', '10'); INSERT 0 1 test=# select * from t; f | i ------+---- 13.5 | 10 (1 row) -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http://bash.org/?255991