On Sat, 20 Oct 2001, Aasmund Midttun Godal wrote:
> Can a rule see the where statement in a query which it has been
> triggered by? or is it simply ignored?? what happens?
>
Looking over your question, I wanted to clarify the problem a bit, so:
(cleaned up example a bit from Aasmund)
-- set up
I apologize for not expressing myself clearly, and for replying without really giving
any new information. In hindsight I understand perfectly well, why you did not want to
continue communication, but I hope that you or someone else, will give me a second
chance on the issue.
Let me try to exp
Can a rule see the where statement in a query which it has been triggered by? or is it
simply ignored?? what happens?
i.e.
CREATE TABLE foo (
id INTEGER PRIMARY KEY,
name TEXT
);
CREATE VIEW bar AS SELECT * FROM foo; -- Great view?
CREATE RULE bar_update AS ON UPDATE TO bar DO
On Sat, 13 Oct 2001, Timothy J Hitchens wrote:
> It's been a while since I used postgresql but today I have converted one
> of my web apps but with one small problem. I goto do a group as
> designed and executed in mysql and I get told that this and this must be
> part of the aggreate etc I am p
Hi All,
Can we create a query to find different values
based on different criteria from a table using case structure. For
example
Select Into
DBComment
Case When localComment Is Null Then Comment
When localComment =
'123' Then 'Numeric Comment'
El
