e when I append nothing to field2, I get
field2, right?
Is this standard behaviour, and if so, is there another append function
that I can use that doesn't behave like this?
3 + unknown value = unknown value
its also unknown if 3 is bigger, smaller or equal to an unknown value.
--
Hans de Brui
Gaetano Mendola wrote:
Hans de Bruin wrote:
...
This is not what I get with a table similiars to your:
test=# select count(*) from user_logs;
count
-
3025880
(1 row)
empdb=# explain analyze
empdb-# select *
empdb-# from user_logs
empdb-# where login_time between (now()-interval &#x
query to transfer the data.
--
Hans de Bruin
http://eratosthenes.xs4all.nl
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
