Re: Bug #915: problem with returning setof with double precision values

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: d(dot)brozek(at)adv(dot)pl, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #915: problem with returning setof with double precision values
Date: 2003-03-21 15:00:01
Message-ID: 12550.1048258801@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)org writes:
> SELECT INTO l_service service* FROM service
> WHERE service.service_id = l_service_id;

Shouldn't that just be

SELECT INTO l_service * FROM service
WHERE service.service_id = l_service_id;

Or possibly

SELECT INTO l_service service.* FROM service
WHERE service.service_id = l_service_id;

but what you wrote looks like a syntax error to me.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Meskes 2003-03-21 15:04:51 Re: [BUGS] Bug #904: Deallocating of prepared statement in ECPG at
Previous Message Tom Lane 2003-03-21 14:38:05 Re: alter table