Newbie question: returning rowtypes from a plpgsql function - Mailing list pgsql-general

From Larry White
Subject Newbie question: returning rowtypes from a plpgsql function
Date
Msg-id d15ea14a041130181068dc87bc@mail.gmail.com
Whole thread Raw
Responses Re: Newbie question: returning rowtypes from a plpgsql function
List pgsql-general
I wrote a function that returns a rowtype.  The rowtype is assigned a
value by a query using SELECT INTO.  The query sometimes will return
no rows.  When it does, the function's return value is a row with no
values.

I would have expected it to return 0 rows, like the query itself.  Am
I doing something wrong or is this the expected behavior?  Is there a
standard way to code around this?  I expected my client code to check
the number of rows returned to decide what to do next.

thanks

pgsql-general by date:

Previous
From: Joel
Date:
Subject: Re: USENET vs Mailing Lists Poll ...
Next
From: "Guy Rouillier"
Date:
Subject: Using default tablespace for database?