Re: [SQL] EXIST / NOT EXIST

> EXISTS is supported (ie. trailing 'S'). I'm a little shamefull ;) Thanks a lot. Rachel ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] EXIST / NOT EXIST

> it is EXISTS I'm a very little shamefull !!! But Thanks at all. Rachel ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] EXIST / NOT EXIST

Hi, I would like to know if the keyword EXIST can be used with PostgreSQL ? I have search in the Reference Manuel et tried a query using EXIST in pgsql, but no result... Thanks a lot Rachel ** [EMAIL PROTECTED] Laboratoire de prehistoire du Lazaret 33 bis

Re: [SQL] Alter table

Thanks a lot, but it's already what i am doing! It's very a pity that there is no way do to this more quickly!!! > alter table xxx rename to temp; > create table xxx as > select field1, field2, ...without some field... from temp; > drop table temp; > > Tomasz Myrta > > Rachel -

[SQL] Alter table

Hi, I wonder if it is possible to remove a field of a table ? I haven't found anything about this into the reference manual. Can I do something like that ?: ALTER TABLE table DROP COLUMN column; Thanks Rachel ** [EMAIL PROTECTED] Laboratoire de prehistoire

Re: [SQL] primary keys

Hi, For example you can do something like that: CREATE TABLE "try" ( "field1"TEXT NOT NULL, "field2"INT4 NOT NULL, "field3"TEXT, PRIMARY KEY (field1, field2)); ** [EMAIL PROTECTED] Laboratoire de prehistoire d