by writing a Function ?
Regards
Phil
- Original Message -
From: Jason Godden [EMAIL PROTECTED]
To: Philip Boonzaaier [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 10:07 AM
Subject: Re: [GENERAL] Bulk Insert / Update / Delete
Hi Philip,
See:
http
, August 19, 2003 6:45 PM
Subject: Re: [GENERAL] Bulk Insert / Update / Delete
On Tue, 2003-08-19 at 22:03, Philip Boonzaaier wrote:
Hi Jason
Thanks for your prompt response.
I'm pretty new to SQL, so please excuse the following rather stupid
question
:
How do I use the (NOT) EXISTS
On Thu, Aug 21, 2003 at 12:56:18 -0400,
Edmund Dengler [EMAIL PROTECTED] wrote:
Wasn't there a feature in some SQL database which was the equivalent of
UPDATE OR INSERT ... based on the primary key? Would this accomplish what
you want (I know that I have a desire for this feature a couple of
I want to be able to generate SQL statements that will go through a list of
data, effectively row by row, enquire on the database if this exists in the
selected table- If it exists, then the colums must be UPDATED, if not, they
must be INSERTED.
Logically then, I would like to SELECT * FROM TABLE
Hi Philip,
Pg is more ansi compliant than most (GoodThing (TM)). You can use the 'when'
conditional but not to do what you need. If I understand you correclty you
should be able to acheive the same result using two seperate queries and the
(NOT) EXISTS or (NOT) IN clause. Failing that have
Philip Boonzaaier [EMAIL PROTECTED] writes:
I want to be able to generate SQL statements that will go through a list of
data, effectively row by row, enquire on the database if this exists in the
selected table- If it exists, then the colums must be UPDATED, if not, they
must be INSERTED.
Doug McNaught [EMAIL PROTECTED] writes:
Philip Boonzaaier [EMAIL PROTECTED] writes:
This message is privileged and confidential and intended for the addressee only.
If you are not the intended recipient you may not disclose, copy or
in any way use or publish the content hereof, which is
On Tuesday 19 August 2003 20:54, Doug McNaught wrote:
Doug McNaught [EMAIL PROTECTED] writes:
I have companies that force crap like this on mailing list postings...
hate
Arrghh.
Not to troll, but another mailing list I am on, anybody posting such
messages/footers is politely