, version of postgresql in Debian woody is 7.2.1
So it is strange, that you have earilier one. Have you installed it from
Debian package or build by hand? If later, it is better to revert to
Debian version.
--
Victor Wagner [EMAIL PROTECTED]
Chief Technical Officer Office:7
working direcory. But there is such command - \cd, at least in 7.2.1
--
Victor Wagner [EMAIL PROTECTED]
Chief Technical Officer Office:7-(095)-748-53-88
Communiware.Net Home: 7-(095)-135-46-61
http://www.communiware.net http://www.ice.ru/~vitus
.
In my (user) point of view, it is obvoisly bugfix, rather than added
feature, so it has right to appear in 7.2.x release.
because of concern about lack of testing, but seeing that we've gotten
several complaints maybe we should do it anyway.
--
Victor Wagner [EMAIL PROTECTED
Victor Wagner [EMAIL PROTECTED] writes:
As far as I understand, following three queries are exactly equivalent:
Same results, but the second two constrain the planner's choice of join
order. See
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/explicit-joins.html
Whether
is simular
with second one and execution time is about 4 seconds. I feel that
it is possible to use execution plan simular with first one,
and make outer join queries fly (as it happens in Oracle).
--
Victor Wagner [EMAIL PROTECTED]
Chief Technical Officer Office:7-(095
field of some table russian words
for this (ETO) and what(CHTO).
Problem doesn't occur on Linux with ru_RU.CP1251 locale
Locale itself is correctly written
perl script
---
use locale;
print ((\375\362\356 eq \367\362\356)?1:0,\n);
returns 0 with locale ru_RU.ANSI1251
--
Victor Wagner
execution
It would be be very nice feature if upon CREATE FUNCTION statement
these checks would be performed.
--
Victor Wagner [EMAIL PROTECTED]
Chief Technical Officer Office:7-(095)-748-53-88
Communiware.Net Home: 7-(095)-135-46-61
http
| true
In Oracle these queries, (rewirtten according to Oracle outer join syntax)
return same result.
--
Victor Wagner [EMAIL PROTECTED]
Chief Technical Officer Office:7-(095)-748-53-88
Communiware.Net Home: 7-(095)-135-46-61
http