Re: Using Execute with Dynamic Raise Commands

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Bernabe <rbernabe(at)sandmansystems(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Using Execute with Dynamic Raise Commands
Date: 2007-11-21 16:43:44
Message-ID: 11916.1195663424@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Robert Bernabe <rbernabe(at)sandmansystems(dot)com> writes:
> I've been trying to create a debugging function that would receive a
> tablename and a list of columns and then the function would display all
> the contents of the table using the RAISE command.

There's no such thing as a "dynamic raise command" --- EXECUTE is for
executing regular SQL statements, not plpgsql things. You hardly need
anything dynamic in your example anyway, seeing that you've built up
the string you want to display just fine.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Pavel SRB 2007-11-21 16:56:27 sql file in the tutorial directory
Previous Message Robert Bernabe 2007-11-21 08:14:40 Using Execute with Dynamic Raise Commands