Re: Bug #915: problem with returning setof with double precision values - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #915: problem with returning setof with double precision values
Date
Msg-id 12550.1048258801@sss.pgh.pa.us
Whole thread Raw
In response to Bug #915: problem with returning setof with double precision values  (pgsql-bugs@postgresql.org)
List pgsql-bugs
pgsql-bugs@postgresql.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: alter table
Next
From: Joe Conway
Date:
Subject: Re: Bug #915: problem with returning setof with double precision