#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Posts
    373
    Rep Power
    12

    running standalone plpgsql function


    hey guys my head must not be on right today but I am not able to run a function that I created and installed.

    I ran the file from psql with \i my_function_file.sql

    then I tried to just run the function from psql

    psql> run_me();

    and it won't do it. I tried looking through all the docs I know I have looked this up before but I can't find it.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Posts
    373
    Rep Power
    12
    rgh nevermind I am truly a jackass...

    SELECT run_me() AS result;

IMN logo majestic logo threadwatch logo seochat tools logo