Hi list!
I pretty newbie in using triggers ,so sorry if this is a known thing.
I was trying to count rows in several tables by one of its column for
example i have :
Table "schedule"
Column| Type | Modifiers
--+---+---
stud
In postgres you the plsql equivalent is 'plpgsql' not 'plsql'.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/05/02, 21:17:38, "jquest jquest"
On Fri, 3 May 2002, jquest jquest wrote:
> Hi,
> I am new to postgresql and to this moment I am using oracle.
> I use posgresql 7.1.2
>
> I try to create very simple ( from doc. examples ) trigger:
>
> CREATE FUNCTION add_one (integer) RETURNS INTEGER AS '
> BEGIN
> RETURN $1 + 1;
>
Hi,
I am new to postgresql and to this moment I am using oracle.
I use posgresql 7.1.2
I try to create very simple ( from doc. examples ) trigger:
CREATE FUNCTION add_one (integer) RETURNS INTEGER AS '
BEGIN
RETURN $1 + 1;
END;
' LANGUAGE 'pgsql';
But the system report:
ERROR:
jreniz writes:
> ''there is no operator '=$' for types 'int4' and 'int4'
It seems you need to put a space into a construct of the sort 'x = $1'.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
---(end of broadcast)---
T
Hi friends!
I'm working in a trigger and I need to put the result
of a query into a variable.
That's very easy- apparently!
The query has a aggregate function like this:
select sum(field) into variable ...
and I'm sure that field and variable are int4 type.
So, when I run this trigger there
