Hi,
I already found a solution. I use
FOR tmp IN EXECUTE ''SELECT.....'' || TG_RELNAME || ''...'' loop
and it works. Thanks anyway
--
regards,
Uros
Wednesday, February 25, 2004, 4:49:19 PM, you wrote:
>> if new."path" = '''' then
>> SELECT INTO tmp "id_category" from TG_RELNAME where
c> "path" = ''Top'';
>> if FOUND then
c> Perhaps you will get some idea if you read the document:
c> 37.6.4. Executing Dynamic Commands
c> Regards,
c> CN
c> ---------------------------(end of
c> broadcast)---------------------------
c> TIP 6: Have you searched our list archives?
c> http://archives.postgresql.org