| 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: | Whole Thread | Raw Message | 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?
| 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 |