Re: [SQL] surrogate key or not?

2004-07-26 Thread Karsten Hilbert
> This reminds me of a project I worked on many years ago, I was pretty much > fresh out of university writing a system for a large medical practice - > itwas principally for accounting purposes. I made lots of suggestions like > Josh's, only to get replies like Karsten's. I the progammer wanted to

Re: [SQL] Trigger functions with dynamic SQL

2004-07-26 Thread Andreas Haumer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi! I have solved the problem! Tom Lane wrote: > Andreas Haumer <[EMAIL PROTECTED]> writes: > >>I just can't figure out where and how many quotation marks >>I have to place in my function. > > > It's messy all right. The "dollar quoting" feature in

Re: [SQL] surrogate key or not?

2004-07-26 Thread sad
hello > This reminds me of a project I worked on many years ago, I was pretty much > fresh out of university writing a system for a large medical practice - > itwas principally for accounting purposes. I made lots of suggestions like > Josh's, only to get replies like Karsten's. I the progammer wa

Re: [SQL] surrogate key or not?

2004-07-26 Thread Iain
> > Because there is no information to be had on this fact. The > > patient IS afflicted by such or she is not. There is no why. > > I begin to see why I spent $2000 this spring to have a doctor tell me what I > *didn't* have ... This reminds me of a project I worked on many years ago, I was prett

Re: [SQL] surrogate key or not?

2004-07-26 Thread Iain
Hi, > But, once a surrogate key is assigned to a row, doesn't it become a > "real" data? For example, I have a bunch of invoices/receipts and I > write down a unique number on each of them. Doesn't the unique number > become part of the information contained by the invoice/receipt itself > (at lea