On Monday 08 March 2004 16:02, Daniel Henrique Alves Lima wrote:
> Yes, i was searching for the name of equivalent function to "||"
> operator...
>
> Now, i've got a new problem: I need to concat three values (two
> column values and a sepator constant). But from documentation: " The
> func
Edmund Bacon <[EMAIL PROTECTED]> writes:
> On Mon, 2004-03-08 at 08:19, Daniel Henrique Alves Lima wrote:
>> Is there a way to create a "functional index" over a string
>> concatenation of two columns ?
> test=# create index str_idx on strtable( textcat(str1, str2) );
As of 7.4 you can do it mor
On Mon, 2004-03-08 at 08:19, Daniel Henrique Alves Lima wrote:
> Is there a way to create a "functional index" over a string
> concatenation of two columns ?
>
> Thanks.
>
Like this?
test=# create table strtable (x int, str1 text, str2 text);
CREATE TABLE
test=# create index str_idx on
Is there a way to create a "functional index" over a string
concatenation of two columns ?
Thanks.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
HAPPY NEW YEAR EVERYONE !
Hi all..
Is there any method of creating functinal index using date() function? I
can't create such an index because of uncacheable function...
I have to select gathered data from specific day of year... So I should
create an index for better performance. How can I
I just installed v7.4 and restored a database from v7.3.4. I have an
index based on a function that the planner is using on the old version,
but doing seq scans on left joins in the new version. I have run
analyze on the table post restore. the query returns in less than 1
second on version 7
