[SQL] PLSQL

2000-09-12 Thread Paulo Roberto Siqueira
Where can I find a tutorial on PL/SQL for postgres? Is there any documentation focused on it on postgres' site? Thank you

[SQL] Select subset of rows

2000-08-27 Thread Paulo Roberto Siqueira
Hi folks, I have this table CREATE TABLE EMPLOYEE (ID_EMP INT4 PRIMARY KEY, NAME VARCHAR(35), SALARY NUMERIC(5,2)); I want to select only the employees' names who have the 5 highest salaries. Paulo Siqueira

[SQL] CREATE TABLE with foreign key and primary key

2000-07-09 Thread Paulo Roberto Siqueira
I'm trying to create a table that has three fields as primary key. These fields must exist in two other tables. id_aluno is primary key in table pessoa, id_curso and id_polo are primary key in table curso_polo. But it seems it won't work. What am I doing wrong? See definitions below. Speci