[ADMIN] Trigger function

Hello, I'm trying to write a trigger that upon inserting a value in a table another table is decremented. Something that could be used in an inventory system, for example. I know it can be done easily outside POSTGRES with PHP but in this case I would like the database to handle it. Example: cre

Re: [ADMIN] Mis-interpreted extended character

> Our database ( (PostgreSQL) 7.3.5 ) uses Unicode encoding: > [...] > For some reason, If I try to use an extended character (ASCII code > > 127) in a string, I get this peculiar result: > [...] Probably your terminal is set to ISO-8859-1 ("latin 1") or something like that, while your databas

[ADMIN] Mis-interpreted extended character

Our database ( (PostgreSQL) 7.3.5 ) uses Unicode encoding:     egreek=# \l     List of databases         Name |  Owner   | Encoding     -+--+-- egreek  | andrew   | UNICODE For some reason, If I try to use an extended character (ASCII code >

Re: [ADMIN] [PERFORM] Tables Without OIDS and its effect

Hello  Neil Conway, We are doing some test on our applications and will let know the community  if without OIDS we could gain more speed . 2. Though I have not written any code in my any of the pgsql functions which depend on OIDS 1. Will without OIDS the functions behave internally