PostgreSQL Discussion - No data found exception

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

No data found exception

hilly

2006-04-05, 11:31 am

I used a no data found exception in Oracle to check if a select
statment returned only one row. I tried using the no data but got back
a ERROR: unrecognized exception condition "no_data". Inoticed in the
documentation there is this note: (Note that PL/pgSQL does not
recognize warning, as opposed to error, condition names; those are
classes 00, 01, and 02.) as no data is a class 02 I assume that is why
I got the error. Is there any other way besides doing a preselect with
a count to see if I return only one row.

Thanks!

Hilly

Sponsored Links