Re: [SQL] How can I simply substatue a value in a query?

2005-06-27 Thread davide
Bryan Encina wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Roy Souther Sent: Monday, June 27, 2005 10:17 AM To: pgsql-sql@postgresql.org Subject: [SQL] How can I simply substatue a value in a query? I want to do a simple substatution of a value i

Re: [SQL] multiple PK with a non UNIQUE field

2005-06-26 Thread davide
if you need a multi column fk don't use the "references" keyword on your create table, instead use the "FOREIGN KEY" keyword for the table, see the "create table" help. so for example (untested) change CREATE TABLE appalto ( cod_op int not null references Opere, cod_co

[SQL] multiple PK with a non UNIQUE field

2005-06-26 Thread davide
Sorry, I 'm a beginner of postgres and I found a problem when I was passed from MySQL: I have to create a referential constraint table APPALTO from a table OPERE that as a composed PK(cod_op,cod_com) where cod_op ISN'T unique. in MySQL: CREATE TABLE opere ( cod_op int NOT NULL , cod_co

[SQL] Log

2004-10-25 Thread Davide Negri
Hello, i have installed the 8.0 beta3-dev1 version of postgres on my pc, and I want to disable log. How can I do? It is possible to disable and don’t write all the log, or how can I write all the log in a specific directory??   Thanks   Negri Davide --- Outgoing mail is

[SQL] Question on the 8.0Beta Version

2004-10-25 Thread Davide Negri
that this happen only with the beta version? When will you plan to release the production version?   Thanks You   Negri Davide --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.779 / Virus Database: 526 - Release Date: 19