yinterval)::time as mytime
from
(select
(s.t ||' minute')::interval as myinterval
from
generate_series(0,1439) as s(t)
)
as myintervalquery
)
as m
mp; make && make install.
There are several options for configure regarding locales,
native-language-support, authentication-protocolls...
The same with pg 8.0.3 on Suse 9.2.
Best regards
Hakan Kocaman
Software-Developer
digame.de GmbH
Richard-Byrd-Str. 4-8
50829 Köln
Tel.: +49 (0)
rwards you need to reload the server (SIGHUP or pg_ctl reload)
More documnetation you fin in the file pg_hba.conf.
You can find this file in the data_directory of your PostgreSQL-Installation,
default is /us/local/pgsql/data/
Best regards
Hakan Kocaman
Software-Developer
digame.de GmbH
Richard-B
atement for the base_table tblprodukte.
I know this looks all very denormalized... hmmm... and in fact it is for
reasons
i can't describe in short terms, so please overlook this uglyness.
If anyone got a clue or pointer how this could be done, i would be very
thankfull.
Best regards
Hak
better not :~))i can then put a testcase together,
that fails on a specific point.
I'll be back with more information.
Best regards
Hakan Kocaman
Software-Developer
digame.de GmbH
Richard-Byrd-Str. 4-8
50829 Köln
Tel.: +49 (0) 221 59 68 88 31
Fax: +49 (0) 221 59 68 88 98
Email: [EMAIL PROT
Hello Berend,
have you considered using pl/r.
http://www.joeconway.com/plr/
I think R got a covariance-function.
http://www.r-project.org/
Best regards
Hakan Kocaman
Software-Developer
digame.de GmbH
Richard-Byrd-Str. 4-8
50829 Köln
Tel.: +49 (0) 221 59 68 88 31
Fax: +49 (0) 221 59 68 88 98
Title: Nachricht
Hi,
try
contrib/tsearch2
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
HTH
Hakan
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of HHDirecto.NetSent: Wednesday, September 27,
2006 4:56 PMTo: pgsql-genera
Hi,
you can find a nice virtual folder implementation in the Opera-Mailclient M2.
Not sure if this also works with IMAP (don't use IMAP yet).
Virtual folders are based on regexes over various fields of a
mail(Subject,From,to,Body,etc.).
Of course this is not db-based, but the feature is neat.
J
s intended ?
Are their other ways to get the OUT-Params as columns ?
Any hints to the docs?
This would be very convenient, i got a function with 4 OUT-Params and
don't want to pay this price for convenience.
As a side note:
I'm glad to have problems like this.
With the other product
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 01, 2007 5:26 PM
> To: Hakan Kocaman
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Functions, composite types and Notice
>
>
> "Hakan Kocaman" &
Thanks Tom.
That did it.
Theirs always something to learn, when i read you.
Best regards
Hakan
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 02, 2007 4:04 PM
> To: Hakan Kocaman
> Cc: pgsql-general@postgresql.org
> Sub
Hi,
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Thorsten Kraus
> Sent: Thursday, March 08, 2007 1:12 PM
> To: postgres general
> Subject: [GENERAL] DB Modeler
>
>
> Hi,
>
> which tools do you use for modelling your databases? I need a
> t
Hi,
Try EXECUTE
http://www.postgresql.org/docs/8.2/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
Best Regards
Hakan Kocaman
Software-Development
digame.de GmbH
Richard-Byrd-Str. 4-8
50829 Köln
Tel.: +49 (0) 221 59 68 88 31
Fax: +49 (0) 221 59 68 88 98
Email
t;
END;
$BODY$ LANGUAGE plpgsql;
select create_geom_table('test_geom_tbl');
It's not exactly the same, hence i don't got some of yout types(geom for
example) laying around, but you get the picture, no?
Best regards
Hakan Kocaman
Software-Development
digame.de Gm
Till later
Hakan Kocaman
Software-Development
digame.de GmbH
Richard-Byrd-Str. 4-8
50829 Köln
Tel.: +49 (0) 221 59 68 88 31
Fax: +49 (0) 221 59 68 88 98
Email: [EMAIL PROTECTED]
digame.de GmbH, Sitz der Gesellschaft: Köln, Handelsregister Köln, HRB 32349
Geschäftsführung: Werner Klötsch, Mar
Hi,
maybe you got some languages like plpgsql already installed?
Thats something pg_restore doesn't really bother.
regards
Hakan Kocaman
Software-Development
digame.de GmbH
Richard-Byrd-Str. 4-8
50829 Köln
Tel.: +49 (0) 221 59 68 88 31
Fax: +49 (0) 221 59 68 88 98
Email: [EMAIL PROT
0.877 ms"
> explain analyze select nimi from firma1.klient where nimi
> like 'Mokter%'
>
> for same data uses index:
> "Total runtime: 9.615 ms"
Hmm...Index-use seems to slow down the query.
Best regards
Hakan Kocaman
Software-Development
digame.de GmbH
cost=232.92..132766.66 rows=37120
width=23)
(actual time=291.600..356707.737
rows=37539 loops=1)
This part is very expensive, but i got no clue why.
Maybe the text-type is not so ideal.
Best regards
Hakan Kocaman
Software-Development
digame.de GmbH
Hi,
> -Original Message-
> From: Richard Huxton [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 03, 2006 11:00 AM
> To: Christian Rengstl
> Cc: Hakan Kocaman; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Query performance
>
>
> Christian Rengstl
the corresponding tables.
If you're using psql try \d yur-table-name.
Best regards
Hakan Kocaman
Software-Development
digame.de GmbH
Richard-Byrd-Str. 4-8
50829 Köln
Tel.: +49 (0) 221 59 68 88 31
Fax: +49 (0) 221 59 68 88 98
Email: [EMAIL PROTECTED]
> -Original Message-
>
20 matches
Mail list logo
