On 02/23/2013 05:26 AM, Tom Lane wrote:
A "virtual" tsvector like that is probably going to be useless for
searching as soon as you get a meaningful amount of data, because the
only way the DB can implement a search is to compute the tsvector
value for each table row and then examine it for the
Hi folks,
I'm building a PHP script for a web site I'm developing. At the
moment, there is absolutely no real data in the database, so obviously
performance is pretty good right now. I'm in the midst of developing an
administration page for the site, which will do a full text search on
sev
On 8/31/2010 8:17 PM, Merlin Moncure wrote:
On Tue, Aug 31, 2010 at 7:56 PM, Raymond C. Rodgers wrote:
Let me stress that this is not a bug in PostgreSQL; if anything at all,
it's only a lack of a stupid feature.
I'm working on a project for a client where I have a table for
Let me stress that this is not a bug in PostgreSQL; if anything at
all, it's only a lack of a stupid feature.
I'm working on a project for a client where I have a table for arbitrary
categories to be applied to their data, and they need to be able to set
the order in which the categories appe
Yeah, I was just going to recommend them; I went through the exact same
thing a few months ago and got the same advice. HostNine looks great,
but an [very] out of date Postgres isn't very helpful. I've enjoyed A2
since I signed up, and it doesn't hurt that they're relatively local (30
miles awa
John DeSoi wrote:
On Nov 16, 2009, at 2:12 PM, Raymond Rodgers wrote:
a2hosting.com shows "unlimited" plans which include Postgres 8.4 (tsearch already included) for about $5/month. If you really need an older version, they might be willing to add your account to an older shared server. I know
Iñigo Barandiaran wrote:
Thanks!
Ok. I've found http://256.com/sources/md5/ library. So the idea is to
define in the dataBase a Field of PlainText type. When I want to
insert a new user, I define a password, convert to MD5 hash with the
library and store it in the DataBase. Afterwards, any u
Richard Huxton wrote:
Raymond C. Rodgers wrote:
In two separate databases that are configured to have latitude and
longitude as double precision fields, I'm having trouble retrieving
records using "between" on the longitude field. I know that I have data
within range, but any
In two separate databases that are configured to have latitude and
longitude as double precision fields, I'm having trouble retrieving
records using "between" on the longitude field. I know that I have data
within range, but any query involving the longitude field fails to find
records.
Here'
Martijn van Oosterhout wrote:
On Mon, Dec 01, 2008 at 10:14:52AM +0100, Bart Degryse wrote:
I'm having a transaction problem when executing prepared statements using the
PHP PDO-PGSQL module.
What happens is this:
On the first $subItem, $checkSubscription goes well, but $insertReminderEntry
Adam Rich wrote:
Now user Ben has passed his mobile to user Josh and we issued Josh his
mobile on 2008-10-15.
1. Is it possible for me to write a query that will have the fields
call.call_id,
call.datetime,
mobile_custodian.user_id,
call.mobile_no
call.charge
that will use call.datetime and lo
Alvaro Herrera wrote:
Raymond C. Rodgers escribió:
The query in which I'm using array_accum() is building a
list of companies and the associated publishers for each. For example:
SELECT c.company_id, c.company_name, array_accum(p.publisher_name) AS
publishers FROM company_table c
Alvaro Herrera wrote:
Raymond C. Rodgers escribió:
Drat, thanks. Other than array_accum() I've never used arrays in
PostgreSQL, so I wasn't aware of that behavior.
Why do you want to use array_accum() in the first place? Maybe there
are better ways to do what you are us
Tom Lane wrote:
"Raymond C. Rodgers" <[EMAIL PROTECTED]> writes:
The only difference I can see is that the quotes don't appear when the
values returned don't contain white space, and do when white space is
present.
That is per the definition of
Some time ago, I found the aggregate function array_accum() listed on
the PostgreSQL web site on a page similar to
http://www.postgresql.org/docs/8.2/static/xaggr.html , and implemented
it in a database that hasn't seen much use. More recently, for a client,
I again used the function but I'm r
First, I want to confess that I am not an SQL expert or even remotely
close. :-)
Second, I believe I pretty much know the answer to my question, but I
would like to have some confirmation if you fine people don't mind.
My situation is this: I have a PHP script that some what dynamically
genera
First, I want to confess that I am not an SQL expert or even remotely
close. :-)
Second, I believe I pretty much know the answer to my question, but I
would like to have some confirmation if you fine people don't mind.
My situation is this: I have a PHP script that some what dynamically
generates
17 matches
Mail list logo
