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 '
n integer;
category RECORD;
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**
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

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.