Thanks to all who have posted. Your comments are very helpful.
On Jul 26, 2012, at 11:04 AM, Vincent Veyron wrote:
> I had assumed the OP _was_
> using Postgres already, and that this was being challenged by the new
> manager.
Yes, that is accurate. The new manager is not familiar with OSS and P
db and manipulating/plotting,
> although I don't know in more detail of what the client's use cases are.
>
>
>
> On Wed, Jul 25, 2012 at 1:41 PM, Mark Phillips
> wrote:
> I am seeking suggestions for business intelligence and data mining tools
> compatible with post
I am seeking suggestions for business intelligence and data mining tools
compatible with postgresql. A new manager at a client's shop is leaning toward
the MS offerings. I would like to be able to speak to the issue.
TIA,
- Mark
--
Sent via pgsql-general mailing list (pgsql-general@postgresql
http://linuxgazette.net/164/sephton.html
I suggest that you review the Postgres Documentation for FTS:
http://www.postgresql.org/docs/9.1/interactive/textsearch.html
One option you may find interesting is the pg_trgm module:
http://www.postgresql.org/docs/9.1/static/pgtrgm.html
hth,
- Mark Phillips
On J
I have read the pg 9.1 doc's about full text search, rambled about the web a
bit looking for related articles, and had good experiences implementing
lightweight prototypes. Now I can sense the depth of the water as I try to
determine a solid approach for implementation.
I would be most gratefu
On Mar 14, 2012, at 6:32 PM, Andy Colson wrote:
> On 03/14/2012 08:16 PM, Scott Marlowe wrote:
>>
>>
>> Can you run it through sed and replace the "-00-00 00:00:00" to
>> NULL (no quotes) ? That should work.
>>
>
> I think COPY (depending on arguments) uses \N by default.
>
> Another op
I am migrating a data set from Oracle 8i to PG 9.1. The process is to export
data into csv files, then use the pg "copy table from file csv header"
statement to load the tables.
There are a number of date columns in the tables that include empty value
(null), valid dates, and some with the time
