Re: syntax question - Mailing list pgsql-sql

From Josh Berkus
Subject Re: syntax question
Date
Msg-id 200302231625.26793.josh@agliodbs.com
Whole thread Raw
In response to syntax question  ("James Cooper" <jim@luckydigital.com>)
List pgsql-sql
James,

> but thats what:
> rec record
> select into rec id from table;
> return rec.id
>
> does
>
> my question was can i do this with a query built inside a string?

No.  That's what I was talking about.  You have to use the loop.


--
Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-sql by date:

Previous
From: Rafal Kedziorski
Date:
Subject: Re: good style?
Next
From: Bruno Wolff III
Date:
Subject: Re: SQL Statements question, why I get errors...