y?)
regards,
Piers Scannell
System Architect, GlobeCast France Telecom
Tel: +44 1707 667 228 Fax: +44 1707 667 206
> -Original Message-
> From: Marcin Zukowski [mailto:[EMAIL PROTECTED]]
> Sent: 30 April 2001 16:30
> To: Tom Lane
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED
's a logic error in your program!
Take things like that away and who knows what little errors slip through
testing and QA ready to bite you after release.
Piers Scannell
Systems Engineer, GlobeCast France Telecom
Tel: +44 1707 667 228 Fax: +44 1707 667 206
> -Original Message--
now how that would affect the speed but it might be the clearest
expression of intent.
Piers Scannell
Systems Engineer, GlobeCast France Telecom
Tel: +44 1707 667 228 Fax: +44 1707 667 206
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 11 Dec
[copied to list]
My understanding, which isn't based on my experience more than reading any
standards, is that a referential foriegn key field in a table can be either,
a value from the referenced table, or null.
Null kinda implies "n/a".
So order-lines on an order might reference a stock item
I'm not sure what the supposed bug is...
> From: Alexei E Korneyev [mailto:[EMAIL PROTECTED]]
[ reformated by PS]
create table t1 (num int4 PRIMARY KEY, name text);
create table t2 (ref int4 references t1 (num) NOT NULL, val text);
insert into t1 values (1
ut "bug" in the subject they would likely be pulled up
to use a more descriptive subject.
rgds
Piers Scannell
Systems Engineer, GlobeCast France Telecom
Tel: +44 1707 667 228 Fax: +44 1707 667 206
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED