X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id CD30CDB4F9
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 18 Nov 2005 04:45:09 -0400 (AST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 62489-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 18 Nov 2005 08:45:10 +0000 (GMT)
X-Greylist: delayed 03:14:25.261445 by SQLgrey-
Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25])
	by svr1.postgresql.org (Postfix) with ESMTP id 30242D7817
	for <pgsql-sql@postgresql.org>; Fri, 18 Nov 2005 04:45:06 -0400 (AST)
Received: from smtp1.netmagicians.com (smtp1.netmagicians.com [202.87.39.91])
	by svr2.postgresql.org (Postfix) with ESMTP id 27F87F0C49
	for <pgsql-sql@postgresql.org>; Fri, 18 Nov 2005 05:30:39 +0000 (GMT)
Received: from mailserver.tatashare.com (unknown [202.149.193.242])
	by smtp1.netmagicians.com (Postfix) with ESMTP id 7D73D3749BF
	for <pgsql-sql@postgresql.org>; Fri, 18 Nov 2005 11:00:25 +0530 (IST)
Received: from aftabn463 (unknown [172.16.16.236])
	by mailserver.tatashare.com (Postfix) with SMTP id D6BB73E5E04
	for <pgsql-sql@postgresql.org>; Fri, 18 Nov 2005 10:57:26 +0530 (IST)
Reply-To: <aalam@tatashare.com>
From: "Aftab Alam" <aalam@tatashare.com>
To: <pgsql-sql@postgresql.org>
Subject: query
Date: Fri, 18 Nov 2005 10:55:24 +0530
Message-ID: <001301c5ec00$7b25b0f0$ec1010ac@aftabn463>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0014_01C5EC2E.94DDECF0"
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0)
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Importance: Normal
X-NetMagic-MailScanner-Information: Powered By NetMagic Mail Protection v1.0
X-NetMagic-MailScanner: Found to be clean
X-NetMagic-MailScanner-From: aalam@tatashare.com
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001]
X-Spam-Score: 0.001
X-Spam-Level: 
X-Archive-Number: 200511/145
X-Sequence-Number: 23396

This is a multi-part message in MIME format.

------=_NextPart_000_0014_01C5EC2E.94DDECF0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello,

I want to create a trigger in PostgresSQL

In trigger, Before inserting the record, if data is already in the table,
the trigger fire the mesaage that data is already there, and after that
trigger ckeck for next insert statement.

How can I do this , Please reply.

Regards,

_____

Aftab Alam


------=_NextPart_000_0014_01C5EC2E.94DDECF0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">


<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR></HEAD>
<BODY>
<P>Hello,</P>
<P>I want to create a trigger in PostgresSQL </P>
<P><SPAN class=3D921122105-18112005>In trigger, Before inserting the =
record, if=20
data is already in the table, the trigger fire the mesaage that data is =
already=20
there, and after that trigger ckeck for next insert =
statement.</SPAN></P>
<P><SPAN class=3D921122105-18112005></SPAN><SPAN =
class=3D921122105-18112005>How can=20
I do this , </SPAN>Please reply.</P>
<P>Regards, </P>
<P>_____ </P>
<P>Aftab Alam </P></BODY></HTML>

------=_NextPart_000_0014_01C5EC2E.94DDECF0--