nested if , and how to trigger....

From: "Muhammad Rusydi" <rusydi(at)cbn(dot)net(dot)id>
To: "postgres general" <pgsql-general(at)postgresql(dot)org>
Subject: nested if , and how to trigger....
Date: 2001-05-05 23:51:49
Message-ID: 001801c0d5be$7374a260$1102a8c0@windows
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
can we do nested if in function ? would you give me some example?

second, if i've create table like this:

create table tb (
code varchar(4),
classes varchar(6),
lecture varchar(4),
th int2,
day varchar(1),
hr varchar(1),
room varchar(4),
primary key (code,kl,ds));

my questions is how to prevent this record to be insert:
code classes lecture th day hr room
K021 1tip01 1011 5 1 1 1111
K022 1tip01 1011 5 1 1 1111

or :
code classes lecture th day hr room
K021 1tip01 1011 5 1 1 1111
K021 1tip01 1012 5 1 1 1111

TIA
Didi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Cramer 2001-05-06 00:05:56 Re: Accounting Schema
Previous Message GH 2001-05-05 23:48:27 Re: Accounting Schema