Hi,
Rodrigo Sakai wrote:
How can I insert a single row in this table???
INSERT INTO employee (emp_salary)
VALUES ((1000.00, '(2006/10/10, 2006/12/10)'));
BTW: are you sure you don't want to use foreign keys instead? Something
like:
CREATE TABLE salaries (
id SERIAL PRIMARY KEY,
salary numeric(10,2) NOT NULL,
t_date t_time NOT NULL
);
CREATE TABLE employee (
employee_id SERIAL PRIMARY KEY,
name TEXT NOT NULL,
salary INT NOT NULL REFERENCES salaries(id)
);
Regards
Markus
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
