Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    2

    Unanswered: about execute dynamic command in pl/pgsql!

    Hi,

    In order to test the use of EXECUTE statement, I wrote such a procedure like this:

    CREATE FUNCTION testfunc() RETURNS int AS'
    BEGIN
    EXECUTE ''DELETE FROM testtab;'';
    RETURN 1;
    END;'
    LANGUAGE 'PLPGSQL';

    After executing, I got such a error: can't find attibute ''delete from test''

    So why?

  2. #2
    Join Date
    Jul 2003
    Posts
    2

    I've got it! thanks

    Don't trouble to think about it.

  3. #3
    Join Date
    Apr 2003
    Location
    Tunisia
    Posts
    192

    Thumbs up Hey how ?

    Come on man tell us how have u fixed that ? (if really it was a trouble) !
    Open up
    Take a look to my Blog http://www.rundom.com/karim2k

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •