In response to Sim Zacks : > > > > I'm trying to write an INSERT INTO statement that will use a DEFAULT > > value when an input parameter is null. > > > Neither of my 2 methods are pretty. > 1) Use a trigger. > 2) Grab and cast the default value from the information_schema.columns > view and plug it in. > > Another option is to build your insert sql as a string and then execute it. Another option: rewrite your function: CREATE OR REPLACE FUNCTION "name_add" (p_name varchar, p_created_date date) RETURNS integer AS $$ BEGIN case when $2 is null then INSERT INTO names(name, created_date) values (p_name, default); else insert into names values ($1, $2); end case; return 1; end; $$ language plpgsql; Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
