Hello
I have created a table
CREATE TABLE MOD48_00_2007 ( ID text, N_GEN int PRIMARY KEY, FORMSTORE text,
COD_NOTAIO text, PA_COGNOME text);
And i insert the rows via a form in ASP. When the form loads i have a functin
that goes and gets the value of the field N_GEN adds 1 to it and shows it to
Shavonne Marietta Wijesinghe wrote:
Hello
I have created a table
CREATE TABLE MOD48_00_2007 ( ID text, N_GEN int PRIMARY KEY, FORMSTORE text,
COD_NOTAIO text, PA_COGNOME text);
And i insert the rows via a form in ASP. When the form loads i have a functin
that goes and gets the value of the fi
Hello,
Is it possible to redesign your table as follows:
create table Mod48_00_2007 (
IDtext,
N_GEN serial not null,
FORMSTORE text,
COD_NOTATIO text,
PA_COGNOMEtext,
constraint pk_Mod48_00_2007 primary key (N_GEN)
);
Your insert simply becomes:
INSERT INTO MOD
Phillip Smith wrote:
If you actually need to know the value of N_GEN in your ASP
application, you will need to query the database first and select the
NEXTVAL from the sequence that the "serial" data type will create,
then use that returned value in your insert - ie, DON'T exclude it
from the
Thanks alot Mario. It did exactly what i wanted. I shall also take alook at the
link you gave for more details..
Shavonne Wijesinghe
- Original Message -
From: M.P.Dankoor
To: Shavonne Marietta Wijesinghe
Cc: pgsql-sql@postgresql.org
Sent: Wednesday, March 07, 2007 12:57
Hi All,
I'm trying to udpate a table containing 13149741 records. And its taking
forever to complete this process.
The update query i'm trying to run is for full text indexing similiar to
UPDATE tblMessages SET idxFTI=to_tsvector(strMessage);
Below are some of the stats which might be helpfu
On Wed, Mar 07, 2007 at 12:28:57AM -0300, [EMAIL PROTECTED] wrote:
> Well, im wondering if is possible using LIKE '%blah%', even better would be
> upper/lower(string) like '%blah%',
Your better bet then is either to index lower(string) or better, on
insert convert everything to lower().
A
--
An
On Wed, 7 Mar 2007, Sumeet wrote:
Hi All,
I'm trying to udpate a table containing 13149741 records. And its taking
forever to complete this process.
The update query i'm trying to run is for full text indexing similiar to
UPDATE tblMessages SET idxFTI=to_tsvector(strMessage);
How big are
Hi list,
I know that there is a md5 internal function on postgresql, but I noticed
that it isn't the more secure today. I would like to know if there is a
SHA-1 function implemented yet of, if not, if the team has plan to introduce
it on PostgreSQL.
Regards ...
--
Ezequias Rodrigues da Rocha
ht
On Wed, Mar 07, 2007 at 05:04:18PM -0300, Ezequias Rodrigues da Rocha wrote:
> Hi list,
>
> I know that there is a md5 internal function on postgresql, but I noticed
> that it isn't the more secure today. I would like to know if there is a
> SHA-1 function implemented yet of, if not, if the team h
On 3/8/07, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
What is the problem you're trying to solve? Md5 is probably good
enough for many cases, but for long-term use, you're right that sha-1
is what you need. Actually, you need sha-256, quite frankly.
Looking at his last mail he's after a passwo
Thanks Oleg,
My String message are Abstracts of papers, I did a
$ select avg(len) from (select length(abstract) as len from master_table
limit 500) E;
avg
---
1355.5907859078590786
(1 row)
so length is approx 1400.
I couldn't find any appropriate way to analyze t
On Wed, 7 Mar 2007, Sumeet wrote:
Thanks Oleg,
My String message are Abstracts of papers, I did a
$ select avg(len) from (select length(abstract) as len from master_table
limit 500) E;
avg
---
1355.5907859078590786
(1 row)
so length is approx 1400.
that'is abou
On 3/7/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:
I know that there is a md5 internal function on postgresql, but I noticed
that it isn't the more secure today. I would like to know if there is a
SHA-1 function implemented yet of, if not, if the team has plan to introduce
it on P
14 matches
Mail list logo
