Re: pl/pgsql problem with return types

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Juris Zeltins <juris(dot)zeltins(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: pl/pgsql problem with return types
Date: 2005-03-11 12:46:42
Message-ID: 9ECE66EE-922B-11D9-B332-000A95B03262@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Mar 11, 2005, at 5:54 AM, Juris Zeltins wrote:

> FOR P IN select pageid from pages
>

This way you are only getting the pageid column. I think what you want
is

FOR P in select * from pages

so that P contains the complete pages record.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Juris Zeltins 2005-03-11 12:50:13 Re: pl/pgsql problem with return types
Previous Message AL ELK 2005-03-11 11:54:56 more execution time