Re: TG_RELNAME problem

From: Uros Gruber <uros(at)sir-mag(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: TG_RELNAME problem
Date: 2004-02-25 17:33:25
Message-ID: 1903637734.20040225183325@sir-mag.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Gamache 2004-02-25 17:40:25 Re: tsearch2 trigger alternative
Previous Message Harry Broomhall 2004-02-25 17:21:50 Re: [PHP] phpBB 2.2 and PostgreSQL support