Re: [GENERAL] Fractions of seconds in timestamps

What about using WHERE f BETWEEN '2012-04-23 00:00:00' AND '2012-04-24 00:00:00'? On 04/25/2012 09:52 AM, Jasen Betts wrote: On 2012-04-24, rihad wrote: As PostgreSQL stores timestamps with a fractional part, does it mean that WHERE f BETWEEN '2012-04-23 00:00:00' AND '2012-04-23 23:59:59'

[GENERAL] Help using user rights

respect, Valentin Militaru Telcor Communications Tel: 0316.900.015 Tel.Mobil:0741.168.267 Fax: 0316.900.001 Prezentul mesaj si orice fisier atasat constituie  informatie confidentiala si este proprietatea exclusiva a Telcor Communications SRL. Mesajul se adreseaza numai persoanei fizice sau juridice

[GENERAL] Fwd: Help using user rights

Hello, I have a question regarding user rights. I have one user in postgres8.01. which connects from a webserver and inserts some data into a table. It only has INSERT access on that table. ON the other hand, on the same table a have an after-insert trigger which executes a function owned by a m

[GENERAL] Problems with a trigger

Hi! I have a problem with an AFTER INSERT row-based trigger. It returns <>. Any ideas? Thanks! Valentin Militaru [EMAIL PROTECTED] SC Telcor Communications SRL Tel. fix: 0316900015 Fax: 031691 Telefon mobil: 0741168267 <>

Re: [GENERAL] Any plans on allowing user-defined triggers to

, imho, what you can do is to prevent the system to delete a project when there are only two in a department, or to insert a new one when there are 8 projects already there. On Tue, 2004-10-26 at 16:18, Mike Mascari wrote: Valentin Militaru wrote: > You can do that. But first you have to do s

Re: [GENERAL] Any plans on allowing user-defined triggers to be

enet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your   message can get through to the mailing list cleanly Valentin Militaru [EMAIL PROTECTED] SC Telcor Communications SRL Tel. fix: 0316900015 Fax: 031691 Telefon mobil: 0741168267 <>