On Wed, Jun 14, 2006 at 11:35:12AM +0200, Leif B. Kristensen wrote: > On Wednesday 14. June 2006 11:09, Martijn van Oosterhout wrote: > >IIRC, if you just declare src as type "record" you can select any > >fields you like. AIUI, declaring a row to be of a specific type is > > only really important if you plan to return it or pass it to another > > function. > > I tried: > > CREATE OR REPLACE FUNCTION get_source_text(integer) RETURNS TEXT AS $$ > DECLARE > src RECORD; > mystring TEXT; > BEGIN > SELECT (source_id, parent_id, large_text) > FROM sources INTO src WHERE source_id = $1;
Why did you put parenthesis there? It looks like you're making a record within a record. You wouldn't have parenthesis there for a normal select statement, would you? Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
