Home > mailing lists

Re: plpgsql FOUND Variable - Mailing list pgsql-general

From	Zygmuntowicz Michal
Subject	Re: plpgsql FOUND Variable
Date	August 28, 2003 09:59:04
Msg-id	003201c36d4a$c8dd9c40$7003a8c0@zvision Whole thread Raw
List	pgsql-general

Tree view

Alex,

I had similar problem with pgsql 7.3.3 and 7.3.4 when
using SELECT INTO RECORD variable. I noticed that
FOUND is always set to TRUE, but if no result is found,
RECORD variable is filled with NULL values.

My workaround was to check for NULL field value,
if there should not be ever NULL (primary key, etc).

---
Zygmuntowicz Michal

pgsql-general by date:

From: Ron Johnson
Date: 28 August 2003, 09:31:52
Subject: Re: SQL Command - To List Tables ?

From: Joerg Erdmenger
Date: 28 August 2003, 10:54:35
Subject: tsearch: how to get a list of stopwords?

Re: plpgsql FOUND Variable - Mailing list pgsql-general

Previous

Next