Hi all,
We've had the go-ahead from the Linux Documentation Project (LDP) guys
to create a new PostgreSQL HOW-TO for a while now. I was going to start
it off just to make sure we had something, so that it could be put
around instead of Al Dev's Database Guide (the bad one).
Well, I haven't had
set nomail
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Hello all,
This may be (hopefully) a very basic question, but I (admittedly, a
pgsql newbie) cannot seem to be able to find an answer to it :(
I have in my database tables, say A, B, and C, all of them referring to
the same objects (e.g. table A contains customer's name, table B his/her
purchase
Actually, I'd recommend
DELETE FROM generators WHERE started <= now() - '30 minutes'::interval;
This might or might not seem more natural than the other way, but it
has the advantage that there's at least a potential to make use of an
index on the "started" column. In practice, because now() is
--- Bruce Momjian <[EMAIL PROTECTED]> wrote:
> Here is an article saying open source databases will not make
> major
> inroads into large businesses during the next five years:
>
> >
http://itmanagement.earthweb.com/datbus/article/0,,11969_796851,00.html
Those same weak arguments were used to di
Quoting Mitch Vincent ([EMAIL PROTECTED]):
> An alternative, though I'm not sure it's better in any way :
>
> DELETE FROM generators WHERE started + '30 minutes'::interval <= now();
Well, that looks a little nicer. Thanks.
--
Paul Tomblin <[EMAIL PROTECTED]>, not speaking for anybody
Q: How
An alternative, though I'm not sure it's better in any way :
DELETE FROM generators WHERE started + '30 minutes'::interval <= now();
-Mitch
- Original Message -
From: "Paul Tomblin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 08, 2001 2:12 PM
Subject: [GENERAL] How sh
I've got a table that I insert a value and a timestamp "now()". Then I
want to delete entries that are older than 30 minutes old. After some
experimentation, I found the following works, but it looks awkward and
backwards. Is there a better, more readable way of phrasing this or
rewriting it?
"Brian C. Doyle" <[EMAIL PROTECTED]> writes:
> Where would I find examples of some C files that connect to a
> postgresql db I am just starting out with c and know Postgresql
> rather well and have done a lot of development with PHP.
>
> The interface I am trying to create is in windows with Pos
Hello all,
Where would I find examples of some C files that connect to a postgresql
db I am just starting out with c and know Postgresql rather well and have
done a lot of development with PHP.
So I need to know what else do I need to write a C program that will
connect to a database in Pos
select * from pg_users;
>From: ÀîÁ¢Ð <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Tom Lane <[EMAIL PROTECTED]>, Dustin Sallings <[EMAIL PROTECTED]>
>CC: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
>Subject: Re: Re: [GENERAL] index on a box
>Date: Sun, 08 Jul 2001 21:02:32 +0800
>
>Tom Lane
Tom Lane£¬
Does anyone who knows a user's information is storeed in what pgSQL's system table?
Thank all!
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
These libs are supposed to be part of the OpenSSL distribution, I think.
Make sure you have installed the openssl package.
If OpenSSL is installed and you still have problems, the library name
might be the problem.
Create a softlink, then: libcrypto.so.0 --> libcrypto.so.0,9.6
Regards,
Peter
Thomas T. Thai writes:
> i'm parsing DMOZ data files, and i need to store the path and later
> reference it to get the associated CatID to store for the parent of the
> child paths. however, some of the paths are larger than 500 chars. would a
> WHERE clause like this:
>
>... WHERE path='top/
Tom Lane wrote:
>
http://thingy.kcilink.com/modperlguide/debug/Handling_the_User_pressed_Stop_.html
> I am not sure how practical that is though; does the web server
> even find out about it when the user presses Stop in a typical browser?
---(end of broadcast)--
From: "Siamack Jabbarzadeh" <[EMAIL PROTECTED]>
Subject: A question multibye
Date: Fri, 06 Jul 2001 18:56:53
Message-ID: <[EMAIL PROTECTED]>
> Dear Sir/Madam:
> I have some questions on multibye languages and I hope you can help
> me? First I was wondering if there is a table (like ASCII table)
16 matches
Mail list logo
