Postgres User wrote: >>> 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. >> > > Thanks... those approaches came to mind. But I need something more > flexible as the Insert functions are generated by an ORM layer. It > has to be simpler. You're not going to get anything simpler than building a string and calling execute. Nor more flexible, come to think of it. BTW - surely the ORM should be generating your defaults for you? -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
