Morning all,
I have a weird problem all of a sudden. In an PG Database I have a
text field that was mapping to MSA/97 as a type Memo and working fine, all
of a sudden the field is mapping to Memo after I relinked it do to some
changes in the PG table and truncating my data with the left
Dear Sir,
I try to use postgreSQL and
C to develop a CGI program. I meet a problem that is I can not fetch the data
from the cursor.
I use embed SQL on Red hat
Linux 6.1 and postgreSQL 6.5.2.
Please tell me where can I download a sample source code to
reference?
Thanks
Hunter Huang
Hi fellow PostgreSQL users.
Here's a query:
DELETE FROM Annonces WHERE Id_Ag IN
(
SELECT Id FROM Installs
WHERE Si_Compte_Actif = 'f'
);
This query will take more than one hour of CPU time
on a PII 333 to execute. Table Installs has about 3000
tuples, and table Annonces about 50.000 .
A
Fabrice Scemama wrote:
>
> Hi fellow PostgreSQL users.
>
> Here's a query:
>
> DELETE FROM Annonces WHERE Id_Ag IN
> (
> SELECT Id FROM Installs
> WHERE Si_Compte_Actif = 'f'
> );
The IN Clause is known to be very very slow. Use the
EXISTS Clause instead.
Regards Herbie
--
~
Fabrice Scemama wrote:
>
> DELETE FROM Annonces WHERE Id_Ag IN
> (
> SELECT Id FROM Installs
> WHERE Si_Compte_Actif = 'f'
> );
>
> This query will take more than one hour of CPU time
> Any ideas about a way to write a single query that fast ?
http://www.postgresql.org/docs/faq-english
I have a problem to install a program on cd i' ve just got
from my university because of a license.dat file i can only get on an internal
net inside the university, that is continuosly updated( every day) the address
is ftp://ftp.cdc.polimi.it/soft/matlab/license.dat
does anybody know whether
- Original Message -
From: "Fabrice Scemama" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 06, 2000 4:03 PM
Subject: [GENERAL] Accelerating subqueries
> Hi fellow PostgreSQL users.
>
> Here's a query:
>
> DELETE FROM Annonces WHERE Id_Ag IN
> (
> SELECT Id FROM In
Hello ,
I want to fecth random rows from a table ... I have defined a cursor
like
EXEC SQL DECLARE C CURSOR FOR SELECT * FROM tablename ;
Now I want to fectch nth row from the table without actually having to
fetch all n-1 rows before i get to the nth row of the table
Any help is most w
when ever I've dealt with a field that would require more text than 250
characters, I've always used the 'text' datatype. It appears I've hit an
example where this won't work. users are trying to insert what amounts to
about 2 pages worth of text and I'm seeing this error:
PostgresSQL query faile
Kevin Heflin wrote:
>
> when ever I've dealt with a field that would require more text than 250
> characters, I've always used the 'text' datatype. It appears I've hit an
> example where this won't work. users are trying to insert what amounts to
> about 2 pages worth of text and I'm seeing this
On Thu, Apr 06, 2000 at 04:48:02PM -0500, Jeff Gerhart wrote:
> Ross,
> Thats for the input. Have a couple of additional questions:
>
> 1- I have the code running and it appears that I get a different result each
> time I sqlcrypt the same string e.g. select sqlcrypt('xyz') gives me a
> different
Use large objects
Kevin Heflin wrote:
>
> when ever I've dealt with a field that would require more text than 250
> characters, I've always used the 'text' datatype. It appears I've hit an
> example where this won't work. users are trying to insert what amounts to
> about 2 pages worth of text a
I'm trying to accomplish some things where some tricky manipulation
of dates would be very helpful.
I'm wondering if it's possible to:
select from a table several records and group by a date column.
The idea is that I have a table with rows for each hour, I'd like
to be able to select a date ra
At 05:35 PM 4/06/00 -0700, you wrote:
>select from a table several records and group by a date column.
just cast your datetime or timestamp (hour) field into a date...
select hour::date, sum(whatever) from table group by hour::date;
Frank
14 matches
Mail list logo