As I have discovered, there is no way to just create index on a column
of type 'point' - postgres complains about not knowing the default
operator class, no matter what index type I use.
Now, my table looks like this:
CREATE TABLE places (
place_id integer primary key,
coordina
On Tuesday 13 January 2009 18:56:33 Brad Balmer wrote:
> Why would the following not work?
> create index tstTbl_idx on test_tbl (cast(xpath ('//uim:upcCode/text()',
> job) as text[]));
Looks like you are missing a namespace definition.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.or
Could somebody please help me with the correct syntax for creating an index on
an xml field. My (simple) table format is:
CREATE TABLE test_tbl (id_cd integer not null, job xml);
INSERT INTO test_tbl VALUES (200,
'http://www.cmpy.com/uim";>202038137003600601236');
I've tried multip
On Wed, 2006-02-01 at 10:46 -0500, Daniel Caune wrote:
> Hi,
>
[snip need for reverse-sort operator class]
>
> SELECT GAME_CLIENT_VERSION
> FROM GSLOG_EVENT
> WHERE PLAYER_USERNAME = ?
> AND EVENT_NAME = ?
> AND EVENT_DATE_CREATED < ?
> ORDER BY EVENT_DATE_CREATED DESC
> LIMIT
"Daniel Caune" <[EMAIL PROTECTED]> writes:
> I would like to create an index on a table, specifying an order clause
> for one of the columns.
Search the archives for discussions of reverse-sort operator classes
(you might also get hits on the shorthand "opclass").
regards,
Hi,
I would like to create an index on a table,
specifying an order clause for one of the columns.
CREATE INDEX IDX_GSLOG_EVENT_PLAYER_EVENT_TIME_DESC
ON GSLOG_EVENT(PLAYER_USERNAME,
EVENT_NAME,
EVENT_DATE_CREATED DESC);
which is not a vali
Is there a way to influence the data type of an index being created?
Some like that would be fine:
CREATE INDEX idx_data2_x ON t_data2(x::int4);
It would be nice to have a workaround for that:
[hs@backup mag]$ time psql -p 5400 test -c "EXPLAIN SELECT * FROM
t_data1 WHERE id > (SELECT AVG(id
At 11:46 AM 15/02/2002 -0500, Tom Lane wrote:
A functional index is sort of like a hidden, precomputed column added to
your table.
One of the things I keep running into is the desire for a mixed
functional/data index. I know the workaround is to build a function that
combines all fields, but w
Uz.ytkownik [EMAIL PROTECTED] napisa?:
i don't know how to create the index about the following statement.
SELECT b.screen_id AS screen_id, b.name AS screen_name
FROM tbl_showlog AS a CROSS JOIN
tbl_screen AS b CROSS JOIN
tbl_company AS c
WHERE a.screen_id = b.screen_id
AND b.company_id = c.comp
i don't know how to create the index about the following statement.
SELECT b.screen_id AS screen_id, b.name AS screen_name
FROM tbl_showlog AS a CROSS JOIN
tbl_screen AS b CROSS JOIN
tbl_company AS c
WHERE a.screen_id = b.screen_id
AND b.company_id = c.company_id
AND c.company_id = 1
AND c.is_act
10 matches
Mail list logo
