# ceo@xxxxxxxxx / 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
