[GENERAL] Implementation of three new operators inside the PostgreSQL

Hi, I am mailing on behalf of the Database Systems Lab, Indian Institute of Science(IISc), Bangalore, India. We have implemented three new operators internal to the PostgreSQL 8.1.2 engine in order to support queries on multilingual data(english and hindi as of now). It can be extended to suppo

[GENERAL] Crash in PostgreSQL-8.2.4 while executing query

. System specs are as: SUSE 10.1, 2GB RAM , P- IV. Thanks in advance, Rupesh Bajaj QUERY select * from semtable as t1, semtable as t2 where exists (select multilingual.english_hopi_lin.element from multilingual.english_hopi_lin, multilingual.english_hopi_lout, multilingual.crosslink where

[GENERAL] Implementation of three new operators inside the PostgreSQL

Hi, I am mailing on behalf of the Database Systems Lab, Indian Institute of Science(IISc), Bangalore, India. We have implemented three new operators internal to the PostgreSQL 8.1.2 engine in order to support queries on multilingual data(english and hindi as of now). It can be extended to support

[GENERAL] Materializing the relation

Hi, What is the meaning of 'materializing' a relation after sequential scan? explain select * from tb1, tb2 where tb1.c1 = tb2.c2; QUERY PLAN Nested Loop (cost=1.03..2.34 rows=3 width=24) Join Filte

[GENERAL] Like operator

Hi, Is Like operator can be used to join two relation. If yes what is its use? And how it is used? Thanks & Regards, Rupesh Bajaj

[GENERAL] When the locially dropped column is also physically dropped

column is automatically physically dropped? or I have to run some command to dropped it physically. Thanks, Rupesh Bajaj