Michael Gould wrote:
Gary,
Based on what I read it wouldn't handle cases where the result should be
MacDonald from macdonald. There are other cases such as the sentence below
I've looked at rationalising names in this manner before, and found
that, depending on the individual, both
Paul Lambert wrote:
Paul Lambert wrote:
chester c young wrote:
I'm trying to use substr() and position() functions to extract the
full host name (and later a domain) from a column that holds URLs.
substring( href from '.*://\([^/]*)' );
Ok, your solution looks better than mine... but I
for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
[EMAIL PROTECTED] ~]$
Please don't reply off-list.
Should I report this as a bug?
--
Cheers
John Summerfield
---(end of broadcast)---
TIP 5
Alvaro Herrera wrote:
John Summerfield wrote:
I have, for some months, been running this daily, but not taking notice
of the results:
[EMAIL PROTECTED] ~]$ cat bin/pg_build
#!/bin/bash
set -xe
cd /home/pgtest/pgsql/pgsql-2007-04-23/
ping -c4 2/dev/null anoncvs.postgresql.org | grep -q 'bytes
Michael Glaesemann wrote:
On Jun 26, 2007, at 2:19 , Achilleas Mantzios wrote:
ΣÏ?ιÏ? ΀Ï?ίÏ?η 26 Î?οÏ?ΜιοÏ? 2007 09:40, ο/η John
Summerfield ÎγÏ?αÏ?ε:
Subjects such as yours don't cut the mustard. Try to summarise your
problem; if I'm interested in the problem then I
Joshua wrote:
Ok,
You guys must be getting sick of these newbie questions, but I can't
resist since I am learning a lot from these email
I'm not fond of people using meaningless subjects, or of people
simultaneously posting the same message to other lists. If one chooses a
meaningless
Is this the right list for this? I'm off the 'net atm and can't easily
check.
I'm running on self-built RHEL 4.
I built from cvs this morning, and get the above error. Running grep
over the source doesn't show anything helpful to me.
The initdb command (sans --auth) works for psql
Alvaro Herrera wrote:
John Summerfield wrote:
Is this the right list for this? I'm off the 'net atm and can't easily
check.
I'm running on self-built RHEL 4.
I built from cvs this morning, and get the above error. Running grep
over the source doesn't show anything helpful to me.
The initdb
Penchalaiah P. wrote:
Information transmitted by this e-mail is proprietary to Infinite Computer Solutions
It may be proprietary, but it shore ain't confidential!
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore
Andrew Sullivan wrote:
On Wed, Apr 11, 2007 at 10:23:34PM +0800, John Summerfield wrote:
Each row's identified by a key, and the key doesn't change.
That doesn't matter.
ADABAS would put the updated record right back where it came from, it
That isn't how PostgreSQL works.
I'm having
Andrew Sullivan wrote:
On Tue, Apr 03, 2007 at 10:16:13PM +0800, John Summerfield wrote:
It is hitting the disk pretty hard now on this machine, but the laptop's
still going too, and the disk seems to run about half the time, part of
a second running, part idle (but the intervals are getting
Andrew Sullivan wrote:
On Wed, Apr 11, 2007 at 12:41:23AM +0800, John Summerfield wrote:
The Linux kernel's clearly doing a lot of work, and the disk supports
You might also be into context-switch hell. What processor, which
kernel, and which Postgres version again?
on opensuse 10.2
Wilkinson, Jim wrote:
I have created a view, called april_may. I need to select this view by
combineing to fields in the database to create the view name etc ...
Jim
Learn to use compose or write and not reply when you want to ask a
fresh question. My email rolled this into the LOCK thread
I have a Java (java 1.1) program that I wrote some years ago, to read
records from a text file and insert it into a ostgresql database.
One of the assumptions I made was that one file contained one day's
data, maybe as many as 1500 records, and I coded it to do the whole lot
as one
Jeff Frost wrote:
On Tue, 23 Jan 2007, Josh Williams wrote:
From: Jeff Frost [EMAIL PROTECTED]
On Mon, 22 Jan 2007, Richard Ray wrote:
...
That's definitely part of it. I'm assuming the above is an abridged
example and the OP is doing something dynamic with the query. The
real trouble
John Summerfield wrote:
Jeff Frost wrote:
On Tue, 23 Jan 2007, Josh Williams wrote:
From: Jeff Frost [EMAIL PROTECTED]
On Mon, 22 Jan 2007, Richard Ray wrote:
...
That's definitely part of it. I'm assuming the above is an abridged
example and the OP is doing something dynamic
wince Now I've figured why I don't get replies, I'm sending again.
Intro:
I have a table that contains much data like this:
SELECT distinct on (date) asx_code,date,open,high,low,close from
sales_summaries where asx_code = 'TLSCA' and date = '2006-12-01' order
by date, time desc limit 10;
17 matches
Mail list logo
