[GENERAL] Java Ex.

hi, Does anyone have a Java example of connecting to a DB and executing a simple SQL command? Thanks, Jason

[GENERAL] Problem with CREATE RULE something ON DELETE (PostgreSQL only executes the first expression)

Hi, I have found what appears to be a bug in PostgreSQL, or is this a feature? I don't think it's a feature, because the postgreSQL documentation state it should work. When creating delete-rules for views, i have found that only the first expression is being executed, when using multiple

[GENERAL] sql question

I have a sql problem which I can't solve. The following table is defined create table AdressGroup ( AdrGroup_Id INTEGER NOT NULL DEFAULT NEXTVAL('adrverw_id_seq'), ZeitDATETIME NOT NULL, Group_Id

[GENERAL] FW: How to select the millisecond/microsecond parts of the datetime column

Hello, Product version: Postgres 6.5.3 SELECT DATETIME('MILLISECOND', 'NOW'::DATETIME) always returns 0(ZERO) and so does 'MICROSECOND'. However a reading of the manuals indicate that the database supports much higher precision values. How do I retrieve the additional precision values