Re: [SQL] Conditional rule?

2000-07-29 Thread Robert B. Easter
On Sat, 29 Jul 2000, André Næss wrote: > This seems ok to me, but I still don't like the invisibility as I pointed > out above. If someone else was to continue my work how would they be able to > see the triggers and procedures? They don't show up on "\d tablename", so it SELECT prosrc FROM pg_pr

[SQL] Localization support

2000-07-29 Thread Max Pyziur
Greetings, Someone recently mentioned that the implementation of localization support in PG7.0.x is different from pre-7.x.x releases. My interest is in getting Ukrainian collation orders working in one of my databases. Any help in this regard would be appreciated greatly. -- Max Pyziur

[SQL] Just 'sql'?

2000-07-29 Thread Itai Zukerman
Hi, I have this: CREATE FUNCTION queue_add() RETURNS OPAQUE AS 'BEGIN INSERT INTO queue ( count, price ) VALUES ( NEW.count, NEW.price ); RETURN NEW; END;' LANGUAGE 'plpgsql' ; I can't figure out how to do this with LANGUAGE 'sql'. Any ideas? Thanks, -itai

Re: [SQL] Conditional rule?

2000-07-29 Thread André Næss
- Original Message - > > And this works as intended. There are however a few things that worries me. > > First of all, I can't seem to find any way to list the trigger and the > > function, they seem invisible. This is problematic because my work will be > > continued by others, and allth