Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group