Hi all,
I am a new joinee to this mailing list. I am using PostgreSql for my
project. We are trying to port a few stored procedures written in SQL to
PGSQL. But i am finding difficulties in doing that. I m new to
Postgresqldont know much about it. I tried a lot of books and online
documents..
--
From: V i s h a l Kashyap @ [Sai Hertz And Control Systems]
[mailto:[EMAIL PROTECTED]
Sent: Monday, June 21, 2004 3:12 PM
To: Pradeepkumar, Pyatalo (IE10)
Cc: [EMAIL PROTECTED]
Subject: Re: [SQL] Function Parameters - need help !!!
Dear Pradeep ,
>CREATE PROC PP_ReadPointByValue
>@Sessi
Hi,
I am writing some triggers for my project.
I am writing a trigger on a table after deleteI want to know how u refer
to the row that is being deleted.
For example for a trigger function after INSERT/UPDATE u refer to the row
being inserted/updated using NEW like this
CREATE FUNCTION
, 2004 12:50 PM
To: Pradeepkumar, Pyatalo (IE10)
Cc: [EMAIL PROTECTED]
Subject: Re: [SQL] Triggers - need help !!!
On 2004-07-07 08:45, UÅytkownik Pradeepkumar, Pyatalo (IE10) napisaÅ:
> Hi,
>
> I am writing some triggers for my project.
> I am writing a trigger on a table after delete.
Hi all,
I m using Postgresql version 7.1.3-2.
I have written a function which accepts 2 arguments and returns matching
tuples from a table based on the arguments passed...but i am having problems
in getting it work.
This is my function -
CREATE TYPE PointType AS(ParamId INTEGER,ParamName VAR
Hi all,
I have 2 tables - table1 and table2. Both the tables are related to each
other. I have written triggers so that if a tuple is inserted into table1,
corresponding values will be inserted into table2. and if a tuple is deleted
from table1 then corresponding tuples are deleted from table2 al
> Hi ,
>
> I have attached the function that I am trying to run. But I am getting the
> following error -
>
> select * from pp_readenum('STAT42','PointDefinitionType') as alias;
> ERROR: syntax error at or near ";"
> CONTEXT: compile of PL/pgSQL function "pp_readenum" near line 41
> <>
>
>
Hi,
I am having a table something like this
CREATE TABLE(PointId integer, PointName varchar(50),PointType integer,
createtime bigint);
where createtime is the current timestamp when the tuple is inserted.
now how do I insert values into the above table. Is there a way to cast
timestamp to
