Hello-
This is my first foray into pl/psql so forgive me if I sound totally incompetent.
I've been writing a few functions, and have come across some screwing data typing issues.
When creating a function which accepts a single argument, things
work just fine, variable can be used throughou
END IF;
END;
' LANGUAGE 'plpgsql';
This is the error message I'm getting by using: ''arg_id'' instead of: (CAST(arg_id AS integer))
SELECT production_scheduled_for_date('2005-05-12', '49');
ERROR: invalid input syntax for integer: &
Its a takeoff of ingres, the ORDBMS (Object-Relational Database Management System) postgres is based on...The origins date to 1977 at UC Berkeley.
On 4/19/05, Daniel Schuchardt <[EMAIL PROTECTED]> wrote:
Just for fun and interrest.What means Postgres? Where and why this name was born?Daniel
Then I guess I need to know how one can encapsulate variables in quotes, yet let the pl/pgsql interpreter interpolate.
In the case of my SELECT INTO, are the quotes even needed to avoid potential confusion with column names?On 4/19/05, Richard Huxton <
dev@archonet.com> wrote:Benjamin Holmberg wrot
