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]
or
rewriting it?
DELETE
FROM generators
WHERE age(now(),started) > interval '30 minutes'
--
Paul Tomblin <[EMAIL PROTECTED]>, not speaking for anybody
"Nobody can be told what the dominatrix is, they have to see it for themselves"
Quoting Paul Tomblin ([EMAIL PROTECTED]):
> In 1996-97, I had just been through the horror of upgrading a lab full of
Sorry, that was 1991-92. What was I thinking?
> machines from SLS 1.03 to Slackware, and then from one Slackware version
--
Paul Tomblin <[EMAIL PROTECTED]>, not
ow compared to
MySQL, so I switched to PostgresSQL.
--
Paul Tomblin <[EMAIL PROTECTED]>, not speaking for anybody
"What we perceive as `God' is simply a by-product of our search for God."
- G'Kar.
---(end of broadcast)-
istribution) as well as CPAN seems to work fine.
--
Paul Tomblin <[EMAIL PROTECTED]>, not speaking for anybody
Programmer (n): One who makes the lies the salesman told come true.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
? And should I vacuum immediately afterwards?
--
Paul Tomblin <[EMAIL PROTECTED]>, not speaking for anybody
The WWW is exciting because Microsoft doesn't own it, and therefore,
there's a tremendous amount of innovation happening.
-- Steve Jobs
---(end of bro
Quoting Tom Lane ([EMAIL PROTECTED]):
> Paul Tomblin <[EMAIL PROTECTED]> writes:
> > Is there a postmaster log other than what's in /var/log/messages?
>
> Yes, the postmaster's stderr output. What is your startup script doing
> with that?
I'm using the
Quoting Tom Lane ([EMAIL PROTECTED]):
> Paul Tomblin <[EMAIL PROTECTED]> writes:
> > I've got PostgreSQL 7.1 installed from rpms on a RedHat 6.2 system. I
> > want the data directory on a separate partition, so I shut down, tar the
> > whole directory into the oth
stgresql start
Is there a way to make this work, or am I going to have to export and
import?
--
Paul Tomblin <[EMAIL PROTECTED]>, not speaking for anybody
Command, n.:
Statement presented by a human and accepted by a computer in
such a manner as to make t
ed the column, I didn't put an index on it. It's Postgres
6.5. And you're right, I haven't vacuumed it recently. And the update is
still running.
--
Paul Tomblin <[EMAIL PROTECTED]>, not speaking for anybody
A fool and his money are soon fl
and completely,
> you showed, quite clearly, how to find out such answers.
I was impressed as well. I didn't know you could use \d to find the
definition of views like that.
--
Paul Tomblin <[EMAIL PROTECTED]>, not speaking for anybody
"Nobody can be told what the dominatrix is,
Is the "BETWEEN" clause inclusive or exclusive? ie if I say "WHERE
latitude BETWEEN 45 and 55", will I get examples where the latitude equals
45 or not? Also, is "latitude BETWEEN 45 and 55" any more efficient than
"latitude >= 45 AND latitude <= 55&quo
www.perl.com.
For GD.pm, you also need the "gd" library. If you're using RedHat Linux,
install the gd (and possibly gd-devel) RPMS.
--
Paul Tomblin <[EMAIL PROTECTED]>, not speaking for anybody
'Usenet "belongs" to those who administ
cessing the request.
We have lost the connection to the backend, so further processing is
impossible. Terminating.
--
Paul Tomblin <[EMAIL PROTECTED]>, not speaking for anybody
"I know not with what weapons World War III will be fought, but World
War IV will be fought with sticks a
Quoting ADBAAMD ([EMAIL PROTECTED]):
> Paul Tomblin wrote:
> > I think I understand now. If this is correct, then doesn't it make sense
> > just to drop that index? At least until I get a lot more data from other
> > countries?
>
> Probably you are rig
Quoting ADBAAMD ([EMAIL PROTECTED]):
> Paul Tomblin wrote:
> > If I try
> > explain select * from waypoint where country = 'BELIZE';
> > a query that will only select one record out of the 8300-odd, it still
> > doesn't use the index.
> >
Quoting ADBAAMD ([EMAIL PROTECTED]):
> Paul Tomblin wrote:
> > I have a table with columns 'country' and 'state'. I put indexes on both
> > of them. I've done the "vacuum analyze" as per the faq. But when I ask
> > it to exp
nd it appears the only
solution is to use the distance between the point and line((0,0),(1,0))
and line((0,0),(0,1)).
--
Paul Tomblin <[EMAIL PROTECTED]>, not speaking for anybody
"A little rudeness and disrespect can elevate a meaningless interaction into a
battle of wills and add drama
18 matches
Mail list logo
