[ADMIN] Testing for a record before update or insert without using a function.

Is it possible to test if a record exists in a table and then if it does do an update on that table or if it doesn't do an insert ? I've looked around the documents and it seems everything points towards a function? Is this the only way or has someone done this before. TIA Geoff --

[ADMIN] Date Problem on Imports to 7.2.1

y! Is there a flag or setting within the database that will allow us to import the date correctly? thanks in anticipation.. Geoff Ellis ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [ADMIN] Date Problem on Imports to 7.2.1 [ SOLVED ]

lt but this default can be changed at compile time or at run time. thanks. Geoff -Original Message- From: Geoff Ellis [mailto:[EMAIL PROTECTED] Sent: 27 August 2003 13:38 To: 'Pgsql-Admin (E-mail)' Subject: Date Problem on Imports to 7.2.1 We have some date problems when impor

[ADMIN] Function problem.

I've got a tiny problem with how I want this function to work. On and insert/delete from a table, I want to check to see if a field contains a certain valule. If it does, not to insert or delete the record. If it doesn't I want to go ahead and insert/delete the record. Here's my function. -- Fun