Hi,
I want a case independent index on people's names and am having troubles.
Here is some output from a postgres run:
/*
* First lets drop the tables and index
*/
drop index upper_name ;
drop function myupper (text);
drop table prosb;
drop sequence prosb_brief_seq;
/*
* now make them
*/
cr
looks like to index doesn't like to use functions which aren't internal.
In your case though, this is not a problem. Rather than defining function
'myupper' use the internal upper directly in the create index statement:
DROP INDEX upper_name;
CREATE INDEX upper_name ON prosb (upper(defendant_nam
I have here Postgresql 6.5.1 running on a Debian Linux system and I am
having some problems.
I have written lots of applications in Perl using the "newstyle", but
there is a problem: it does not disconnect from the database. Like:
If I have 20 processes running at the same postgres start fork
At 20:41 +0200 on 27/10/1999, Stuart Rison wrote:
> In the example you give, you could do the changes with two UPDATE
> commands:
>
> 1) UPDATE questions SET order=0 WHERE order=5;
> 2) UPDATE questions SET order=order+1 WHERE order<5;
>
> It becomes more tricky when you try and move a question
hi, there,
I'm using select from 2 tables (join). the key fields are not the
same type (char and varchar). result: psql got disconnected. I tried
several times, then, I make the type the same. then, it works.
now, although not urgent, I'm still curious: is it a bug or,
I did not install PG right
then, why use int, isn't char better? (almost no need for batch).
>From: Herouth Maoz <[EMAIL PROTECTED]>
>To: "Shawn T. Walker" <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: [GENERAL] Auto Ordering
>Date: Mon, 1 Nov 1999 17:57:13 +0200
>
>At 20:41 +0200 on 27/10/1999, Stuart Rison w
