Re: RETURNS SETOF table; language 'sql'

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mario(dot)splivalo(at)mobart(dot)hr
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: RETURNS SETOF table; language 'sql'
Date: 2005-11-09 18:49:41
Message-ID: 18100.1131562181@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Mario Splivalo <mario(dot)splivalo(at)mobart(dot)hr> writes:
> When I do:
> SELECT * FROM get_ads(1004);
> i get:
> ERROR: query-specified return row and actual function return row do not
> match

The example as given works fine for me in 7.4.9. Maybe you need an
update, or maybe you're not telling us the whole truth about what you
did.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mario Splivalo 2005-11-09 21:28:20 Re: RETURNS SETOF table; language 'sql'
Previous Message Mauricio Fernandez A. 2005-11-09 16:21:58 Re: Como ejecutar una funcion insert en plpgsql....