hi everybody,
i got the following problem:
i have a database running on a postgresqlserver version 7.4.1, in the
database is a table with 4 columns containing
float-numbers. what i want to do now is, to convert the type of those
columns from float to numeric, because
i want to limit the posi
Hello,
I would like to call multiple PL/pgSQL procedures (i.e. functions
returning void) from INSERT, UPDATE and DELETE RULEs.
Using "SELECT some_procedure();" is a possible way to do that, but it
causes a dummy result table to be delivered to the application invoking
the INSERT/UPDATE/DELET
Do you tried to create an index on the account column ?
I think it may help.
Regards
-
Bernard LAMBEAU
Département d'Ingénierie Informatique
Université Catholique de Louvain-La-Neuve (Belgium)
On 5/22/05, Andrea
am 22.05.2005, um 10:17:53 +0200 mailte Andreas Kretschmer folgendes:
> > can you help me how to fix them.
> > Can I using function to fix them (how?)
>
> It is possible to create a extra table for the balance and a trigger for
> insert/update that calculates the balance for the transactions-tabl
am 22.05.2005, um 12:15:56 +0800 mailte Muhyiddin A.M Hayat folgendes:
Nice SQL ;-)
>
> everything is ok, but when record > 100 that query eat all my cpu
> process and take a long time, i have wait for 3 mimutes but query
I think, because for every record in your result is a full table sc
