By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,820 Members | 1,051 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,820 IT Pros & Developers. It's quick & easy.

TG_RELNAME problem

P: n/a
Hello ,

When i use TG_RELNAME with SELECT INTO and from

Create or replace function "fn_i_generate_path_category"() returns trigger as '
declare
n integer;
category RECORD;
tmp RECORD;
begin
raise notice ''%'',TG_RELNAME;
if new."path" = '''' then
SELECT INTO tmp "id_category" from TG_RELNAME where "path" = ''Top'';
if FOUND then
...............

When function is started i get error:

ERROR: syntax error at or near "$1" at character 29

What can I do

--
Best regards,
Uros mailto:ur**@sir-mag.com
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 22 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.