> Triggers are generally more robust. Quick example:
> NEW.noteid := SELECT 1+ COALESCE( (SELECT noteid FROM "Notes" WHERE
> userkey=NEW.userkey ORDER BY noteid DESC LIMIT 1), 0 );
Can you please write me the whole trigger? I've been reading the manual for
an hour and I have no idea in where to a
On Wed, Jun 24, 2009 at 01:43:20PM +0200, Marko Pahić wrote:
>Hello,
>I have two databases, and I want the same structure, and if I change the
>structure of one database it changes the structure of the other. In
>documentation I saw that the syntax goes something like this: CREATE T
W dniu 24 czerwca 2009 13:43 użytkownik Marko Pahić napisał:
> Hello,
> I have two databases, and I want the same structure, and if I change the
> structure of one database it changes the structure of the other. In
> documentation I saw that the syntax goes something like this: CREATE TABLE
> "Use
Hello,
I have two databases, and I want the same structure, and if I change the
structure of one database it changes the structure of the other. In
documentation I saw that the syntax goes something like this: CREATE TABLE
"User" () INHERITS database2."User"; But it's not working like this, and I
c