On 10/02/2014 01:49 PM, Andrus wrote:
Steps to reproduce:
Run commands
create temp table test (kuupaev date, kellaaeg char(5) ) on commit
drop;
create index test on test ((kuupaev||kellaaeg));
in
"PostgreSQL 9.3.4, compiled by Visual C++ build 1600, 32-bit"
Observed result:
E
Steps to reproduce:
Run commands
create temp table test (kuupaev date, kellaaeg char(5) ) on commit drop;
create index test on test ((kuupaev||kellaaeg));
in
"PostgreSQL 9.3.4, compiled by Visual C++ build 1600, 32-bit"
Observed result:
ERROR: functions in index expres
On Wed, Aug 26, 2009 at 07:13:41AM -0700, xaviergxf wrote:
> How can i create a index to index all the fields that has the type
> INTEGER, in the following table:
>
> create type properties_types as enum('INTEGER', 'STRING', 'FLOAT');
>
> create table properties_types(
>value text NOT NULL,
Hi,
How can i create a index to index all the fields that has the type
INTEGER, in the following table:
create type properties_types as enum('INTEGER', 'STRING', 'FLOAT');
create table properties_types(
value text NOT NULL,
value_type properties_types NOT NULL
);
insert into properties_
"carter ck" <[EMAIL PROTECTED]> writes:
> I am wonderring the differences between creating an index on several columns
> of a table and an index on each column of a table.
> For example, following is my select query:
> select * from my_table where myrowid='abc' and mytask='TEst 1' and
> myday!=
Hi all,
I am wonderring the differences between creating an index on several columns
of a table and an index on each column of a table.
For example, following is my select query:
select * from my_table where myrowid='abc' and mytask='TEst 1' and
myday!='holiday';
Which of the following is
Net Virtual Mailing Lists wrote:
CREATE TABLE table2 (
table2_id INTEGER,
table2_desc VARCHAR,
table3_id INTEGER[]
);
CREATE TABLE table3 (
table3_id INTEGER,
table3_desc VARCHAR
);
What I need is an "indirect index" (for lack of a better phrase) that
allows me to do:
SELECT b.table3_id
The problem in my case is that the view does a join between table2 and
table3 and I want to do a select on a value from table2. So at the point
the expansion happens, I am actually doing a query on a column that does
not exist in table3 - it only exists in table2.
Given what you said, perhaps a b
4 novembre 2004 11:15
To: Net Virtual Mailing Lists
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Creating index on a view?
Net Virtual Mailing Lists wrote:
> My question is regarding creating an index on a view, or perhaps
> another way to accomplish this.
Views are just macro expansi
Net Virtual Mailing Lists wrote:
> My question is regarding creating an index on a view, or perhaps
> another way to accomplish this.
Views are just macro expansions of queries (in a manner of speaking).
To make queries on views use indexes, you create the indexes on the
underlying tables in th
Hello,
First, let me apologize for my flurry of emails as of late... I'm working
on something which seems particularly difficult (at least to me)...
My question is regarding creating an index on a view, or perhaps another
way to accomplish this. For example:
CREATE TABLE table1 (
table1_id S
11 matches
Mail list logo
