[SQL] multiple insert

2004-09-29 Thread van Elsacker Frans
We developed a program to follow up the time one is working on a particular job. They start and stop the time counter different times a day, now for already tree years. Everything works fine but for a short while (august?) there are very few actions from which the beginning time is inserted t

Re: [SQL] FOREIGN KEY and AccessExclusiveLock

2004-09-29 Thread Achilleus Mantzios
Hmm, (something went wrong with some mailer) Tom Lane wrote: > We're adding a trigger to it. >From the docs: ACCESS EXCLUSIVE Conflicts with locks of all modes (ACCESS SHARE, ROW SHARE, ROW EXCLUSIVE, SHARE UPDATE EX

[SQL] SELECT with Function

2004-09-29 Thread Paulo Nievierowski
Hello, This is my first message to pgsql-novice. I create plpgsql function "myfunc(integer)" thats returns of type record with values from table X (the function decides what record must be select). The parameter is an keyprod existing in table X and in table A. It run well sending in psql: SELEC

Re: [SQL] Porting problem from Informix to Postgres...

2004-09-29 Thread Marco Gaiarin
Mandi! Jeff In chel di` si favelave... > 1. use to_char to format the date however you like ...this seems the best solution, many thanks to all! ;) -- dott. Marco Gaiarin GNUPG Key ID: 240A3D66 Associazione ``La Nostra Famiglia''http://www.sv.