Newbie question: returning rowtypes from a plpgsql function

From: Larry White <ljw1001(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Newbie question: returning rowtypes from a plpgsql function
Date: 2004-12-01 02:10:24
Message-ID: d15ea14a041130181068dc87bc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guy Rouillier 2004-12-01 02:12:13 Using default tablespace for database?
Previous Message Joel 2004-12-01 01:45:51 Re: USENET vs Mailing Lists Poll ...