tring-type info.
I'd start w/ downloading a list as mentioned here:
http://answers.google.com/answers/threadview?id=596822
And run it through a wee perl script using
http://search.cpan.org/~maurice/Text-DoubleMetaphone-0.07/DoubleMetaphone.pm
to make phonetic matches ...
Then I'd run your own data through DoubleMetaphone, and clean up
matches if not too many false positives show up.
Cheers,
Andrej
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
ropriately, w/ name
w/o a clean match being reported for human interaction =o)
If I had a task like that to perform I'd dump the data out to file
and have a good go at it w/ sed & awk, or perl, depending on
how complex & voluminous the data is.
Cheers,
Andrej
--
Please don't
he imported data are chained (have a link to previous/next event)
Any chance of seeing actual data? Might be a job for awk/perl rather
than the RDBMS.
Cheers,
Andrej
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
re trying to be consistent
> between Regular Expressionimplementation an the other implementations do not
> have this limit.
Interesting. The POSIX standard for REs dictates this limit; which
implementations
you're using don't adhere to it?
Cheers,
Andrej
--
Please don'
On 29/07/2008, Chris Preston <[EMAIL PROTECTED]> wrote:
> How do I setup a password table that I only want to encrypt 1 field
> "password"
http://www.postgresql.org/docs/8.3/interactive/pgcrypto.html
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.
On 17/06/2008, Jorge Medina <[EMAIL PROTECTED]> wrote:
> hi guys.
> I want know if it's possible create a select from 2 database or create
> a view in one of them.
The short answer is no.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://
ENDING','COMPLETED')
) as dm2
on dm2.alias1 = dm.alias1
where dm.subclass_alias='Post'
and alias2 in ('PENDING','REDRAFT');
Cheers,
Andrej
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.american.edu/e
)
What I'd really like is to BOTH Post AND reply, with the alias2 for both.
Hope this was as clear as mud? :)
Cheers,
Andrej
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.american.edu/econ/notes/htmlmail.htm
) ...
basically it will omit ANYTHING + two slashes at the beginning
of a string. Then it will match everything BUT a slash, and as
much of that as possible since regex are greedy by default
(hence the host name he was looking for) ... and everything
AFTER a slash will be omitted.
Cheers,
Andrej
--
On 8/8/07, Ranieri Mazili <[EMAIL PROTECTED]> wrote:
> Exist something like it for postgresql?
I thought that's what views are for
> Thanks
Cheers,
Andrej
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.american.
On 7/13/07, Nis Jørgensen <[EMAIL PROTECTED]> wrote:
Don't attribute to malice what can be adequately explained
by incompetence.
He didn't :)
Nis
Cheers,
Andrej
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://w
ct.
Highly irritating.
Cheers,
Andrej
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
On 7/2/07, John Summerfield <[EMAIL PROTECTED]> wrote:
Andrej:
I don't post links; I often find them unhelpful because I can't read
them at the time I'm reading email.
esr's article contains good advice, but there's room for argument on
some of his points. Pr
p://www.catb.org/~esr/faqs/smart-questions.html
:)
-- Cheers,
Andrej
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.american.edu/econ/notes/htmlmail.htm
---(end of broadcast)---
TIP 7: You can
On 5/14/07, Penchalaiah P. <[EMAIL PROTECTED]> wrote:
Any one can help in this
Operating system? Postgres version?
How does psql behave? Anything in the logs?
Cheers,
Andrej
---(end of broadcast)---
TIP 9: In versions below 8.0, the p
On 4/19/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Problem consist of transportation data, received by SQL, into external
world. As i already wrote, it's very difficalt for users (in practice)
to use libraries of additional language (php , perl, etc) for that.
I offer to put one feature i
utodrs_deal_lines.txt > c:/temp/autodrs_deal_lines.tab
Then use copy like so:
\copy table from 'c:/temp/autodrs_deal_lines.tab' delimiter E'\t' null ''
Cheers,
Andrej
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
one help me determine the parameters for postgres.conf which will
help me vacuum fast. I'm running postgres on a server with 32 gigs of ram
and 8 processors.
And the disk subsystem is ?
Thanks,
Sumeet.
Cheers,
Andrej
---(end of broadcast)--
ail he's after a password hash.
To the OP:
Currently there's no support in pg for sha algorithms, but you
could always implement those in your application and store
the hash in pg that way.
Cheers,
Andrej
---(end of broadcast)---
TIP 5: don
store that in a varchar or char field. When the user authenticates
the password gets hashed in the app and compared against the
stored hash.
Cheers,
Andrej
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your des
20 matches
Mail list logo
