On Wed, Jun 14, 2006 at 11:04:19AM +0200, Leif B. Kristensen wrote: > One question: When I have a function like this: > > CREATE OR REPLACE FUNCTION get_source_text(INTEGER) RETURNS TEXT AS $$ > DECLARE > src sources%ROWTYPE; <snip> > What do you suggest that I write instead of "SELECT * FROM sources INTO > src", when src is defined as sources%ROWTYPE? The table sources is > defined as: 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. Have a ncie day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
