Hi,
I have learnt from certain texts that bitmap indexes are very useful for
large DSS (decesion support systems).
bitmap indexes are currently not available in postgresql.
My question is in what way is a normal btree index in pgsql
inferior to bitmap indexes (found in oracle for example).
is
Hello,
I want to solve the following problem:
CREATE TABLE Ref( Id int ) ;
CREATE TABLE Import ( Idint,
Other varchar(42),
Flag int,
Tstimestamp ) ;
CREATE TABLE Data ( Idint,
Other varchar
Hi Stephan
>> So, how can I get the same result above without using time() ??
>>Or if it not possible, how can I extract (yes, I tried with extract()
>>function too) time from a timestamp column?
>> I know it's quite simple question... but I haven't find any clue!
>>
>
> In general you
Hi , All!
Could someone clarify me :
When I want to store BLOB's internally in database (for example jpeg )
should I use bytea or OID? Is OID something like BFILE in Oracle 8i?
If both are appropriate for internal BLOB why I can't use
update image set picture=lo_import('Myfile') where imag
On Thu, 22 Aug 2002, Lucas Brasilino wrote:
> Hi Stephan
>
> >>So, how can I get the same result above without using time() ??
> >>Or if it not possible, how can I extract (yes, I tried with extract()
> >>function too) time from a timestamp column?
> >>I know it's quite simple question..
See the email about bitmapped indexes linked to from the TODO list item
on bitmaps. Bitmap indexes allow arbitrary indexes to be combined into
a single index. Btree indexes can not be combined.
---
Rajesh Kumar Mallah. wr
