Re: [GENERAL] [fulltext]Gin index full scan

On Mon, May 11, 2009 at 8:04 PM, esemba wrote: > > I've a table with tsvector column named meta_vector. Over this column there > is a gin index. When I execute query like: > select id from theses where meta_vector @@@ to_tsquery('cs', 'foo | (!bar)') > > I get an errror message: query requires ful

[GENERAL] Is this a bug or a feature? Column visibility in subquery from outer query

postgres=# create table public.ps_test_x (x1 oid, x2 oid, x3 oid); CREATE TABLE postgres=# create table public.ps_test_y (y1 oid, y2 oid, y3 oid); CREATE TABLE postgres=# explain select * from public.ps_test_x where x1 in (select x1 from public.ps_test_y); QUERY PLAN --

Re: [GENERAL] Daylight saving time question

Bayless Kirtley wrote: How can I tell PostgreSQL to use daylight saving time when applicable? Times returned by the database are one hour behind. it uses your client's specified local time zone to determine whether or not DST is in effect. SET TIME ZONE 'America/New York'; or SET TIM

[GENERAL] Daylight saving time question

How can I tell PostgreSQL to use daylight saving time when applicable? Times returned by the database are one hour behind. TIA Bayless

Re: [GENERAL] Excel and pg

Sergio- the idea to accomodate mandarin audience is a good one..china represents a vital growing economy and will appreciate the fact you are writing in their lang There are about 12 different ways of accomplishing this featureset in J2EE TC would be the lightest implementation GF or WL would

Re: [GENERAL] Excel and pg

Martin Gainty wrote: > There are about 12 different ways of accomplishing this featureset in J2EE > TC would be the lightest implementation For the unitiated: Tomcat (from the Apache Software Foundation) > GF or WL would be the more heavyweight J2EE AppServer offerings For the uninitiated: Gla

Re: [GENERAL] Excel and pg

Ivan Sergio Borgonovo wrote: > I'd like to know if: > - it is possible to "load" in an Excel sheet a table (view, query > result) coming from postgresql and to use those data to do further > computation/presentation work on Excel? Certainly. You can do it through the ODBC interface via VB, an

[GENERAL] Need help

Hi, I am running Dspace 1.5.1, which is an institutional repository software. I am using postgresql-8.3 there. Here, i am facing the problem is: our server suddenly went down and after searching, i found out that, the OS crashed. So, i had to re-install my OS again. But, the problem is, I couldnot

[GENERAL] Excel and pg

I've to deal with a volunteer pet project and I wouldn't like to get crazy fighting with the idiosyncrasies of Access but still I've no time to build up an interface that will be enough user friendly to overcome the resistance of something new. So I thought just to use Excel 2003 as the front-end

[GENERAL] subscribe

subscribe end