| From: | April L <april(at)i-netco(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | KEYEXISTS function |
| Date: | 2002-07-04 14:46:20 |
| Message-ID: | 3.0.5.32.20020704104620.02d0f008@mail.i-netco.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
In an old DOS database program I programmed in for years, there was a handy
function called
KEYEXISTS("value",index)
value of course was only in quotes if it was a string.
I'm imagining this could be pretty easily created as a function for
postgres, and I'm wondering if someone has already done this?
The recent discussion here on the Novice list sparked my memory of how very
often a KEYEXISTS type of function is useful. I know in my own work, an
attempt to insert a record where the primary key would be duplicated,
results in an error to the user, so I have to error trap and cannot "try to
insert and do something else if insert doesn't work" - I have to look for
the existence of a conflicting record and not insert if there is one.
Thank you,
- April
| From | Date | Subject | |
|---|---|---|---|
| Next Message | caroline kenny | 2002-07-04 15:26:48 | Carraige Return issue |
| Previous Message | Manfred Koizar | 2002-07-04 13:18:12 | Re: best match question: please help |