Hi!
I've compiled Postgresql-7.2 with locale, recode and multibyte support.
I read the documentation about locale support, and I understand what
this is ussefully when I need the system/database messages in a
determinated language. Is correct this?
I need to support the japanish language, for
Le Jeudi 14 Février 2002 11:13, Manuel Trujillo a écrit :
I need to support the japanish language, for example, and I need when a
make a query to database, with PHP, the results are in japanish.
Can the database make this directly, or I need to make this via php
programation, making a php
On Thu, 2002-02-14 at 13:45, Kumar, Lakshmi (Cognizant) wrote:
How can i change the Grants over tables to other users ... is there any
round about way ?
Or where could be the problem.
First, I imagine you have permissions to make this.
When I want to change the permissions over a table, or
HELP!!!
Okay, now that I have your attention :). I have a table with
about 560M rows in it. Performance is usually pretty good except when I
do a specific query:
SELECT fooid FROM foo
WHERE bazid = 123456
ORDER BY score DESC LIMIT 100 ;
My index looks like:
CREATE INDEX foo_index ON
Roy Cabaniss [EMAIL PROTECTED] writes:
southern=# DROP DATABASE template1;
ERROR: DROP DATABASE: database is marked as a template
Sorry about that; but perhaps you should have read the whole section I
pointed you to. The procedure that would actually work would be
something like (as
Brian McCane [EMAIL PROTECTED] writes:
CREATE INDEX foo_index ON foo (bazid, score desc) ;
Which would be exactly what I want, and would complete in a split second.
Instead, this thing runs FOREVER (okay, it just seems that way to my
client :). Is there any way to get the equivalent index
Brian McCane [EMAIL PROTECTED] writes:
Then I tried your way (after I realized I had already selected a
specific bazid so it didn't matter if it was descending :),
Yup, that's the little flash of insight that the planner is incapable
of having :-(
regards, tom lane
On Thu, 14 Feb 2002, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
In fact, I am unsure why you are specifying the primary column in the
ORDER BY anyway if you know it will be a single value, except perhaps to
try and get it to use the index, right?
Exactly. The sort ordering
Here is another peeve
Having to specify the type of a constant in a SELECT DISTINCT 'foo'...
I which I had more spare time to contribute...
Jean-Luc
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
In fact, I am unsure why you are specifying the primary column in the
ORDER BY
Brian McCane wrote:
On Thu, 14 Feb 2002, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
In fact, I am unsure why you are specifying the primary column in the
ORDER BY anyway if you know it will be a single value, except perhaps to
try and get it to use the index, right?
Bruce Momjian [EMAIL PROTECTED] writes:
Tom, do we have a TODO item here?
I'm not excited about it; it seems a weird case and there's a simple
query change to get the right thing to happen. AFAICS we'd have to
expend a lot of planner cycles to detect this case, and most of the
time those
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Tom, do we have a TODO item here?
I'm not excited about it; it seems a weird case and there's a simple
query change to get the right thing to happen. AFAICS we'd have to
expend a lot of planner cycles to detect this case, and most
Hi,
OpenFTS team is glad to announce a pre-alpha release of
OpenFTS perl version, which is available for testing from
openfts.sourceforge.net. We've created openfts-general
mailing list for general discussion. Details is available at
http://lists.sourceforge.net/lists/listinfo/openfts-general
We
13 matches
Mail list logo