From: CHRIS HOOVER <CHRIS.HOOVER@companiongroup.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: raise is not working
Date: Thu, 23 Sep 2004 13:04:00 -0400
Message-ID: <NY86502f-00f427a0@companiongroup.com> (raw)
tom,
They were a double quote. I switched all of the double quotes out for single
quotes but still not go. The function appears to run and return no results
but, I don't get any raises. I have even tried moving the raises to be fire
first lines in the function, but to no avail.
That first assignment was ment to set SQL_Str to hold the value: select * from
clmhdr. I don't think I need to single quotes. That would set it to 'select
* from clmhdr', right???
I'm very confused as to why I'm not seeing anything here.
I looked at my settings, and client_min_messages, and server_min_messages are
both set to the default of notice.
Thanks for any help,
Chris
------------------( Forwarded letter 1 follows )---------------------
Date: Thu, 23 Sep 2004 12:52:07 -0400
To: chris.hoover
Cc: Josh.Berkus[josh]@agliodbs.com.comp, pgsql-sql@postgresql.org.comp
From: Tom.Lane[tgl]@sss.pgh.pa.us.comp
Sender: pgsql-sql-owner+m19055@postgresql.org.comp
Subject: Re: [SQL] raise is not working
"CHRIS HOOVER" <CHRIS.HOOVER@companiongroup.com> writes:
> Sorry for the delay, here is the function.
> CREATE OR REPLACE FUNCTION "public"."clmhdr_grid_query" (varchar, varchar,
> varchar, varchar, varchar, varchar) RETURNS SETOF "public"."clmhdr" AS'
> ...
> SQL_Str := "select * from clmhdr";
If those are really double quotes then I'd expect you to be getting
errors along the lines of
ERROR: column "select * from clmhdr" does not exist
long before you get to the RAISEs. You need doubled single quotes, eg
SQL_Str := ''select * from clmhdr'';
See the docs.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: CHRIS.HOOVER@companiongroup.com, tgl@sss.pgh.pa.us
Subject: Re: raise is not working
In-Reply-To: <NY86502f-00f427a0@companiongroup.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox