Hello, i have an old system where used implicit casting
float<->integer
numeric<->float
numeric<->integer
I want define implicit casts, but postgresql don`t know cast priority
now postgresql have PREFERRED flag, but only flag
I can`t define prefer level like
Integer=0
Numeric=1
Float=2
Maybe
tex
07.01.2011 13:01, Nicolas Barbier пишет:
That seems like a use case for LATERAL, which is not supported yet.
Some recent discussion seems to be
http://archives.postgresql.org/pgsql-hackers/2009-09/msg00292.php>.
Nicolas
Thank you for your answer. Sorry, what i don`t find it myself.
But I can`
Hello, Hackers!
We have a project developed at Interbase and Firebird.
Now we try use PostgreSQL and have some problem
Why doesn`t work this query?
select table1.field1, func1.field2 from table1 left outer join
func1(table1.field1) on true where func1.field3 in (20, 100);
If i have other than
27.07.2010 21:37, Tom Lane пишет:
Right. Because of the OR, it is *not* possible to conclude that
d2.basedon is always equal to 234409763, which is the implication of
putting them into an equivalence class.
In the example, we do have d1.id and d2.basedon grouped in an
equivalence class. So in
20.07.2010 18:31, Robert Haas:
According to the EXPLAIN ANALYZE output, your "slow" query is
executing in 0.007 ms, and your "fast" query is executing in 0.026 ms
(i.e. not as quickly as the slow query). Since you mention that it
takes 7 s further down, I suspect this is not the real EXPLAIN AN
*i wrote to
pgsql-b...@postgresql.org
they tell me write to
pgsql-performa...@postgresql.org
they tell me write here*
*I don`t whant know how optimize query myself (i know it), and i think
it must do planner.*
I have a query:
SELECT d1.ID, d2.ID
FROM DocPrimary d1
JOIN DocPrimary d2
