On 12/20/06, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
On Mon, Dec 18, 2006 at 22:18:43 -0500,
Chansup Byun <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm trying to set up a trigger to prevent any duplicate entries into
> my table. But I couldn't figure out how to make my trigger work.
Couldn't you use a unique constraint to do this?
Yes, I found that from a private email. it works great.
Thanks,
- Chansup
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match