| From: | PFC <lists(at)boutiquenumerique(dot)com> |
|---|---|
| To: | Ragnar Hafstað <gnari(at)simnet(dot)is>, "Kenneth Gonsalves" <lawgon(at)thenilgiris(dot)com> |
| Cc: | "Richard Huxton" <dev(at)archonet(dot)com>, weberp(at)paradise(dot)net(dot)nz, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Query performance problem |
| Date: | 2005-03-18 09:10:10 |
| Message-ID: | op.snts28pfth1vuj@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> DEFAULT applies to INSERTs, NOT NULL applies to UPDATEs too.
In MySQL it applies to both (ie. if you UPDATE to an invalid value, it
sets it to 'something').
NOT NULL without default is useful when you want to be sure you'll never
forget to put a value in that column, when there is no meaningful default.
Also for foreign keys : what would be the default value of a foreign key ?
>
> gnari
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2005-03-18 13:19:28 | Re: Query performance problem |
| Previous Message | Ragnar Hafstað | 2005-03-18 07:32:52 | Re: Query performance problem |