[GENERAL] Creating a row during a select

Hi, is there a way to have PostgreSQL insert a new row into a table during a SELECT query if no row is found by that query? -- Best regards, Michal mailto:[EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have you

[GENERAL] Multiple operations on single rule, revisited

Hello, the following is a rework of what I wanted to achieve when posting yesterday. Since that post didn't seem to attract attention, I tried to do what I wanted to do differently. Now, creating a RULE for a view allows defining several operations for it. I was happy to discover that actually

[GENERAL] Multiple operations when updating a view - works in Postgres, doesn't in the app

Hello, I'm fairly new to the more advanded functionality of PostgreSQL, especially writing functions in PL/pgSQL and have something of a design question, which doesn't seem to be answered anywhere I can google to. I've a view created in my schema, for which I'm adding rules for updating and