[GENERAL] Time without seconds

2008-12-02 Thread Andreas Kraftl
Hello, is it possible to get the time without the seconds and without the usage of a formatting function? Example: CREATE TABLE test.testtime ( thetime time without time zone ); INSERT INTO test.testtime (thetime) VALUES ('12:34:56'); INSERT INTO test.testtime (thetime) VALUES ('23:45'); SELECT

Re: [GENERAL] Fulltext index

2008-11-10 Thread Andreas Kraftl
Am Sat, 08 Nov 2008 09:44:17 +0100 schrieb Andreas Kraftl: > How can I create a full text index over b? Hello thanks for the answers. But nothing matches my problem. I read the manual again and decide me for an other way. I change my table that it looks like: lang| t

[GENERAL] Fulltext index

2008-11-08 Thread Andreas Kraftl
rspaltigen Indexe SQL state: 0A000 means, gin doesn't accept multicolumn indexes. Any ideas? Greetings Andreas -- Kraftl EDV - Dienstleistungen Linux, Linuxschulungen, Webprogrammierung Autofabrikstraße 16/6 1230 Wien -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] FullText index

2008-11-04 Thread Andreas Kraftl
Hello, we have a table where is a column with language ISO code like en, de, ... How can i build the index, depending on this languagecode? >From the manual: to_tsvector([ config regconfig , ] document text) Where is documented what "config regconfig" can be? Thanks Andreas -- Sent via pgsql-