Could you please post the schema and query?
Also, I'm assuming you VACUUM on a regular basis?
Mike M.
--- Bill Garrett <[EMAIL PROTECTED]> wrote:
> I've searched the list archives and read the FAQ,
> neither of which seem to
> describe my current situation:
>
> I'm running Linux 2.2.10 on a pro
Thanks Aaron,
That is exactly what I wanted. Much more simple then what I was thinking.
On 10-Aug-99 Aaron Seigo wrote:
> hi wim..
>
>>select * from company where created
>>is between (lastpaid + 14 days) and (created + 28 days);
>
> assuming that lastpaid and created are dates, pgsql will
hi wim..
>select * from company where created
>is between (lastpaid + 14 days) and (created + 28 days);
assuming that lastpaid and created are dates, pgsql will handle the
addition quite nicely for you... as examples:
test=> select '4-1-1999'::date + 7;
?column?
--
04-08-1999
(1 row)
I've searched the list archives and read the FAQ, neither of which seem to
describe my current situation:
I'm running Linux 2.2.10 on a production webserver, along with PostgreSQL
6.5.1 (in RPM format from ftp.postgresql.org). My main database is a set
of names/addresses/etc. tables for our memb
Hi,
I am creating a script that sends out reminders to subscribers to a site who
have not paid. I can't figure out the math that will add 7 days to a date.
I want something like this:
select * from company where created
is between (lastpaid + 14 days) and (created + 28 days);
I can't figure
On Mon, 9 Aug 1999, Jonathan R. Karlen wrote:
JRK> Is there a way to drop a field from a table? ALTER TABLE seems to only
JRK> allow the adding and modification of fields.
Try to select all content to temporary table, then drop old table, create
new with unneeded column(s) removed, and them res
Hello there,
Could anybody advise me how can I create composite index for table when
one of key fields is of boolean type?
Schema is as follows:
create table test (indoor bool, pos int, name varchar(64) NOT NULL,
check (pos >= 0 and pos <=32000));
create unique index test_pkey on test (indoor
You need to increase your max backends. The default for 6.4.2 was 64. I
believe it is a configure option (or it's in config.h).
You might also need to increase your semaphore limits (that's a kernel
option).
> -Original Message-
> From: Yin-So Chen [SMTP:[EMAIL PROTECTED]]
> Sent: Sunda
Hmm, char16 is not a currently recognized type - what version of
postgresql are you using? In 6.5, upper(foo) works for all the char and
text types of foo I can find.
Ross
On Tue, Aug 10, 1999 at 02:30:54PM +0300, Safa Pilavcý wrote:
> Please help
>
>
> - Original Message -
> From
At 14:30 +0300 on 10/08/1999, =?iso-8859-9?Q?Safa_Pilavc=FD?= wrote:
> Please help
Char16 has little support. Any possibility of changing the definition to
char(16)?
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
--Referential integrity:
--1. Don't allow to add a detail without header
--2. Delete all details in cascade if one decide to delete the
header
--3. Update details' key in cascade if header's key is changed
DROP TABLE header;
CREATE TABLE header (
year
INTEGER NOT NULL,
Please help
- Original Message -
From: Safa Pilavcı <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 06 Ağustos 1999 Cuma 14:48
Subject: [GENERAL] uppercase of char16
> hello ,
> My problem is with SQL statement,
> I have a field like,
> my_fieldchar16
>
> this field conta
Anybody that knows anything about Dome ( http://www.htc.honeywell.com/dome/
) ?
It seems to be a quite extensive CASE tool. Can I use it to build a
Database layout and let it generate sql statements to create the database??
I'm doing a db layout in Logic Works' Erwin. It can generate SQL
statements to create the database. Of course it doesn't include support
for PostgreSQL (yet) but I wondered which syntax was closest of the
supported ones.
These are supported:
DB2
SQL Server
Rdb
Oracle
SQLBase
Watcom/SQL Anywhere
I
14 matches
Mail list logo
